IB_Transaction property

Applies to
TIB_Statement

Declaration
Property IB_Transaction : TIB_Transaction;

Description
Transaction to be used for this statement.

If the IB_Connection property is referencing a TIB_Database component then this property is automatically set to reference a transaction that is internally contained in the TIB_Database instance. This is for BDE emulation only.

If this property is left to nil and it is not referenced to an IB_Database then if the statement is prepared it will create its own internal transaction instance. Thus, if you never assign this property your statements and datasets could all be maintain their own individual transactions. This is most likely an undesirable thing. This internal transaction instance defaults to AutoCommit as true and Isolation of tiCommitted so that they will all be able to see what eachother are doing.