Difference between revisions of "TSQLTransaction"
From Lazarus wiki
Jump to navigationJump to searchm |
|||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | {{TSQLTransaction}} | ||
{{Infobox databases}} | {{Infobox databases}} | ||
− | '''TSQLTransaction''' [[image:tsqltransaction.png]] is a non-visual component that intermediates between a database connection 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>. | ||
'''SQLTransaction1'''.Database := SQLConnection1; | '''SQLTransaction1'''.Database := SQLConnection1; | ||
SQLQuery1.Transaction := '''SQLTransaction1'''; | SQLQuery1.Transaction := '''SQLTransaction1'''; | ||
− | |||
− | |||
== Freepascal Documentation == | == Freepascal Documentation == | ||
* [http://www.freepascal.org/docs-html/fcl/sqldb/tsqltransaction.html TSQLTransaction doc] | * [http://www.freepascal.org/docs-html/fcl/sqldb/tsqltransaction.html TSQLTransaction doc] | ||
* [[TDataSet]] | * [[TDataSet]] | ||
− | |||
{{LCL Components}} | {{LCL Components}} | ||
− | |||
− |
Revision as of 07:38, 10 April 2017
│
English (en) │
français (fr) │
日本語 (ja) │
русский (ru) │
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