Difference between revisions of "TSQLTransaction"
From Free Pascal wiki
Jump to navigationJump to searchLine 2: | Line 2: | ||
'''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]]. | ||
− | A TSQLTransaction is used to guard a series of queries such that either all of the queries are executed by a <tt>Commit</tt> or none using <tt>Rollback</tt>. | + | A TSQLTransaction is used to guard a series of queries such that either all of the queries are executed by a <tt>Commit()</tt> or none using <tt>Rollback()</tt>. |
'''SQLTransaction1'''.Database := SQLConnection1; | '''SQLTransaction1'''.Database := SQLConnection1; | ||
SQLQuery1.Transaction := '''SQLTransaction1'''; | SQLQuery1.Transaction := '''SQLTransaction1'''; | ||
− | |||
− | |||
== Freepascal Documentation == | == Freepascal Documentation == |
Revision as of 21:18, 24 February 2017
References:
Tutorials/practical articles:
Databases |
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