Subject Re: [IBO] db commit and other transactions
Author Helen Borrie
At 06:27 AM 2/05/2004 -0400, you wrote:
>Delphi 5, IBO 4.3.A, Firebird 1.5, TIBOxxxx
>If there are multiple active transactions within a program and a db commit
>is issued for one transaction what happens to the other transactions? Must
>they be refreshed or will they continue without the data just committed?

It depends on the transaction isolation of the other transactions. If the
TI of another transaction is ReadCommitted (tiReadCommitted in IBO) it will
see the committed work of any other transaction. A tiConcurrency or
tiConsistency transaction won't see any work that is committed after it began.