Applies to
TIB_Transaction

Declaration
Procedure Activate;

Description
Some statements may process an alteration to data or metadata that IBO is not smart enough to detect. This could be due to calling the ExecuteImmediate() method where a DML or DDL is performed. It could also be a case where a stored procedure is used as a SELECT proc in a TIB_Cursor and it also has DML statements in it. In such cases it is necessary to manually activate the transaction so that IBO knows something has happened to activate the transaction.

If AutoCommit is true and StartTransaction wasn't previously called this will cause an immediate SavePoint to be generated which will cause the Status to go back to tsInactive or tsActivePending depending on the states of the datasets.

If AutoCommit is false or a logical transaction was explicitely started the Status will be set to tsActive and TransactionIsActive will now reflect true.

IBO calls this method internally whenever a dataset posts a change or a DML statement is executed successfully. It also calls this method when a stored procedure is executed and the StoredProcHasDML property is set to true.