TSQLTransaction

Databases portal

References: General info Libraries Field types Controls FAQ SQL how-to Working With TSQLQuery In-memory database applications Tutorials/practical articles: Overview 0 - Database set-up 1 - Getting started 2 - Editing 3 - Queries 4 - Data modules SQLdb Programming Reference Databases Advantage - MySQL - MSSQL - Postgres - Interbase - Firebird - Oracle - ODBC - Paradox - SQLite - dBASE - MS Access - Zeos

TSQLTransaction 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

• TSQLTransaction doc
• TDataSet