[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] | Reference for unit 'SQLDB' (#fcl)

# TSQLQuery.Transaction

Transaction in which to execute SQL statements

## Declaration

Source position: sqldb.pp line 695

`published property TSQLQuery.Transaction : TDBTransaction;`

## 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

TSQLQuery.Database |  | The TSQLConnection instance on which to execute SQL Statements
TSQLConnection |  | An abstract class representing a connection to a SQL Database
TSQLTransaction |  | Transaction in which a TSQLQuery is handled