Subject Re: [firebird-support] Re: Data Lost after altering table
Author Helen Borrie
At 04:48 PM 22/01/2004 +0000, you wrote:
> > In my experience, mixing DDL and DML statements doesn't always
> > work as they are supposed to
>Thanks. I issued a lTx.commit after the initial alter and it seem to
>have fixed things. It would have been nice to keep it in one
>transaction--but maybe this is a limitation of FB/IB?

It's a "limitation" of both Fb/IB and common sense!! This isn't
Paradox: you are not working with physical structures. Dropping things
involves DML operations on the system tables (along with a whole bunch of
other stuff done by triggers) that will be rejected if the dependent object
is in use. Transactions *protect* databases from people who want to change
the structures of objects while they have data changes pending!!