TSQLTransaction

From Lazarus wiki
Revision as of 06:31, 10 April 2017 by E-ric (talk | contribs)
Jump to navigationJump to search
Databases portal

References:

Tutorials/practical articles:

Databases

Advantage - MySQL - MSSQL - Postgres - Interbase - Firebird - Oracle - ODBC - Paradox - SQLite - dBASE - MS Access - Zeos

TSQLTransaction tsqltransaction.png is a non-visual component that intermediates between a database connection such as TSQLConnection and a TDataSet-derivative like a TSQLQuery.

A TSQLTransaction is used to guard a series of queries such that either all of the queries are executed by a Commit() or none using Rollback().

 SQLTransaction1.Database := SQLConnection1;
 SQLQuery1.Transaction := SQLTransaction1;

Freepascal Documentation