TSQLQuery.Transaction property

Declaration

property Transaction:;

Description

Transaction must be set to a SQL transaction (of type TSQLTransaction) component. All SQL statements ( SQL / InsertSQL / updateSQL / DeleteSQL) etc.) will be executed in the context of this transaction.

The transaction must be connected to the same database instance as the query itself.

Multiple TSQLQuery instances can be connected to a transaction at the same time. If the transaction is rolled back, all changes done by all TSQLQuery instances will be rolled back.

See also

• Database
• TSQLConnection
• TSQLTransaction