Transaction in which to execute SQL statements.
Source position: sqldb.pp line 714
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.
|
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. |