Subject Re: [IBO] transaction behavior
Author Helen Borrie
At 10:01 AM 26/05/2004 +0800, you wrote:
>Good day.
>
>I have a few question of confirm. Suppose I have one ib_connection and
>two ib_transaction connected thru this one ib_connection. Both
>ib_transaction are read committed. Suppose the first ib_transaction post
>a record without committing it. Will the second transaction see the
>newly post record?

No. Transactions can never see the uncommitted work of other
transactions. That is known as "dirty read" and Firebird/IB do not support
it (and never will).

Helen