Difference between revisions of "TSQLTransaction"
From Lazarus wiki
Jump to navigationJump to search (Created page with "'''TSQLTransaction''' is a non-visual component that intermediates between a database connection and a TDataSet derivative like a TSQLQuery. '''SQLTransaction1'''.D...") |
m |
||
(8 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | '''TSQLTransaction''' is a non-visual component that intermediates between a database connection and a [[TDataSet]] derivative like a [[TSQLQuery]]. | + | {{TSQLTransaction}} |
+ | {{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]]. | ||
+ | |||
+ | 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] |
* [[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