Subject Re: [IBO] Cursor doesn't see value
Author Helen Borrie
At 07:26 AM 17/03/2004 +0000, you wrote:
>In an application, I have two components pointing to the same data
>table in Firebird 1.5.
>
>The first component is a TIBOTable and is part of an explicit
>transaction which commits a value "Y" to the table. Just after the
>commit, a TIB_Cursor pointed at the same data opens. It has nothing
>listed in the "IB_transaction" property. The cursor is active but sees
>the just commited value as blank. Why would this happen?

It will be using the default transaction. With TIBO*, the isolation level
of the default transaction is tiConcurrency. It won't see what another
transaction committed until itself is committed.

Why are you leaving the ib_transaction property blank?

Helen