[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 655

published property TSQLQuery.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

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


Documentation generated on: Sep 28 2017