TSQLConnection.BeginTransaction Method

Initiates a new transaction in the associated database.

Pascal

function BeginTransaction: TDBXTransaction;

C++

__fastcall TDBXTransaction BeginTransaction();

Description

Call BeginTransaction to start a new transaction against a database server that supports transactions. (MySQL servers do not support transactions.) You can check the TransactionsSupported property to determine whether the server supports transactions. If the server does not support transactions, BeginTransaction does nothing.

The method returns a TDBXTransactioninstance.

If the transaction is successfully started, BeginTransaction sets the InTransaction property to true.

Updates, insertions, and deletions that take place after a call to BeginTransaction are enlisted in that transaction until another overlapping transaction is started or until the application calls CommitFreeAndNil to save the changes or RollbackFreeAndNil to cancel them.

Tip: If the server does not support multiple transactions, check the status of the InTransaction property to be sure that another transaction is not already in progress.

Tip: When working with overlapped transactions, you can indicate the transaction to which a dataset belongs by setting its TransactionLevel property to the transaction identifier you assign in this method.