| Subject | How can a FDB lose all its procedures and triggers in regular use? |
|---|---|
| Author | Chuck Belanger |
| Post date | 2009-08-28T04:50:21Z |
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
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