Subject Re[2]: [ib-support] Changing metadata in a production database
Author Daniel Rail

> It was two different transactions: (1) and (2) in the example.

Connections or Transactions? Reading your earlier posts you mention
connections. Depending how the BDE manages the transactions, it is
possible to have 2 connections using the same transaction.

Another plausible explanation might be, that since transaction (1) is
already started and there are record updates. The ALTER TABLE in
transaction (2), might actually only be applied to the table once
transaction (1) is completed, either by COMMIT or ROLLBACK. I don't
know if a COMMIT RETAINING would work, you'll have to try it.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (