| [Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] |
Transaction in which to execute SQL statements
Source position: sqldb.pp line 665
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 |