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


Transaction in which to execute SQL statements


Source position: sqldb.pp line 695

published property TSQLQuery.Transaction : TDBTransaction;


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



The TSQLConnection instance on which to execute SQL Statements



An abstract class representing a connection to a SQL Database



Transaction in which a TSQLQuery is handled

Documentation generated on: May 14 2021