Thanks, Alan for the reply.

Actually, the BLR was gone. When distributing the DB to users, I
intentionally delete the Procedure source code.

I think Dmitry hit the nail. This user has been having subtle computer
problems. I have a routine that backs up the DB whenever the application
is closed and every 15 times it does a backup and restore (this is a
desktop application, using embedded). It happened during the last
restore. Something happened during that restore. Typically the user
leaves his computer on, but hibernating and does not turn it off.

Chuck

>> Hello:
>>
>> Just had a first.
>>
>> A user of a desktop application I created which uses FB embedded, 2.1,
>> started having problems. I had him send his DB for me to look at.(I got
>> a madExcept bug report that said a particular procedure could not be
>> found.) It is about 170mb with about 40 tables, procedures (13),
>> Triggers (62), UDF (160), etc. When I looked at his DB, it was missing
>> all the Triggers and Procedures.
>>
>> How can that happen without destroying the DB? or more simply: How can
>> that happen? Is this a typical hardware fault? I used IBExpert to do a
>> DB validation and it passed.
>>
>> BTW, he just bought a new computer and will be transferring everything
>> over tomorrow morning.
>>
>>
>> Thanks,
>>
>> Chuck Belanger
>>
>
> do you mean missing the source of these objects? or the BLR?
> You can delete the source easily without deleting the BLR, but you need to
> know how to do it.
> Alan
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>

[Non-text portions of this message have been removed]