Subject RE: [firebird-support] How can a FDB lose all its procedures and triggers in regular use?
Author Alan McDonald
> 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