Difference between revisions of "TSQLTransaction"

From Lazarus wiki
Jump to navigationJump to search
m
m
Line 1: Line 1:
 +
{{TSQLTransaction}}
 
{{Infobox databases}}
 
{{Infobox databases}}
 
'''TSQLTransaction''' [[image:tsqltransaction.png]] is a non-visual component that intermediates between a database connection such as [[TSQLConnection]] and a [[TDataSet]]-derivative like a [[TSQLQuery]].
 
'''TSQLTransaction''' [[image:tsqltransaction.png]] is a non-visual component that intermediates between a database connection such as [[TSQLConnection]] and a [[TDataSet]]-derivative like a [[TSQLQuery]].

Revision as of 07:31, 10 April 2017

English (en) français (fr) 日本語 (ja) русский (ru)

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