Difference between revisions of "TSQLTransaction"
From Lazarus wiki
Jump to navigationJump to searchLine 1: | Line 1: | ||
{{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>. | 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>. |
Revision as of 21:16, 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; DataSource1.DataSet := SQLQuery1; DBGrid1.DataSource := DataSource1;
Freepascal Documentation