Subject | RE: [firebird-support] How can a FDB lose all its procedures and triggers in regular use? |
---|---|
Author | Alan McDonald |
Post date | 2009-08-28T05:09:47Z |
> Hello:do you mean missing the source of these objects? or the BLR?
>
> 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
You can delete the source easily without deleting the BLR, but you need to
know how to do it.
Alan