TSQLTransaction

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

From the Free Pascal wiki, page "TSQLTransaction", as it stood on 2024-03-15 after a change by Ariben, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's Licensing page. If you have concerns about this material, message the admin.