The Commit method, which is used to permanently store modifications made in the current transaction to the database.

The Rollback method, which is used to cancel all modifications made in the current transaction to the database.

How to Use the Sample

Navigate to the location given above and open IFDPhys_Transactions.dproj.

Press F9 or choose Run > Run.

Files

File in Delphi

Contains

IFDPhys_Transactions.dprojIFDPhys_Transactions.dpr

The project itself.

fTransactions.pasfTransactions.fmx

The main form.

Implementation

When you run the application, clik the Use Connection Definition combo box and select an option in order to define a connection. When the connection is defined, the sample uses the CreateCommand method of IFDPhysConnection to create a command interface. Then, the sample implements the following database transaction features in run time:

Set up the transaction isolation level

The sample sets the Isolation property of IFDPhysTransaction to xiReadCommitted to allow the reading of committed (permanent) changes made to the database by other simultaneous transactions. This is the default value of the Isolation property.

Start a transaction

The sample uses the StartTransaction method to start a new database transaction. During the transaction, the sample uses the Prepare method of IFDPhysCommand to execute a DELETE command. The SQL command is the following: 'delete from {id FDQA_TransTable}'.

Commit the transaction

The sample uses the Commit method to permanently store modifications made in the current transaction to the database.

Rollback the transaction

The sample uses the Rollback method to cancel all the modifications made in the current transaction.