TIB_TransactionState Type

Unit
IB_Components

Declaration

TIB_TransactionState = ( tsNone,
                         tsInactivePending,
                         tsInactive,
                         tsActivePending,
                         tsActive,
                         tsSavePointPending,
                         tsCommitRetainingPending,
                         tsCommitPending,
                         tsCommitRefreshPending,
                         tsRollbackRetainingPending,
                         tsRollbackPending,
                         tsRollbackRefreshPending );

Description
Status of the transaction.


tsNone - No transaction has been physically or logically started.
tsInactivePending - A transaction is in the process of physically starting.
tsInactive - Transaction has been started but no DML or DDL has been executed causing it to become active.
tsActivePending - A dataset in the transaction is in an edit state that will cause the transaction to become active if it is to be successfully posted.
tsActive - DML or DDL has been executed causing transaction activation. Either AutoCommit is false or the StartTransaction method was called allowing DML & DDL chages to be held within transaction control of the application. If AutoCommit were true then there would be an immediate SavePoint and the state would go back to tsInactive or tsActivePending.
tsSavePointPending - A call to SavePoint has been made and it is in the process of executing it.
tsCommitRetainingPending - Transaction is about to commit but be retained.
tsCommitPending - Transaction is about to commit and end.
tsCommitRefreshPending - Transaction is about to commit and end except the datasets will all be refreshed. This happens when Refresh( true ) is called.
tsRollbackRetainingPending - Transaction is about to rollback and retained.
tsRollbackPending - Transaction is about to rollback and end.
tsRollbackRefreshPending - Transaction is about to rollback and end except all datasets will be refreshed in the process. This happens when Refresh( false ) is called.