difference between TSQLTransaction and TSQLQuery.transaction
lazarus / 16-Databases

----------------------------------------------------------------------
mangakissa · 2013-11-13 12:46

I noticed that I can't do a  TSQLQuery.transaction.commit. Therefore I
need TSQLTransaction.
But  the property transaction in TSQLQuery must be filled in. So I
connect my TSQLTransaction to TSQLQuery.
As far as I know TSQLQuery.transaction is a pointer to
TSQLTransaction.

Why can't I use TSQLQuery.transaction.commit to commit a record?

----------------------------------------------------------------------
kpeters58 · 2013-11-14 03:04

You have almost answered your own question:

Because the Transaction property just links to an instance of
TSQLTransaction which provides the Commit method.

----------------------------------------------------------------------
LacaK · 2013-11-14 06:17

Quote from: mangakissa on November 13, 2013, 01:46:01 pmWhy can't I
use TSQLQuery.transaction.commit to commit a record?

Because Transaction in TSQLQuery is of type TDBTransaction (not
TSQLTransaction) inherited from TDBDataSet
You can use: (SQLQuery1.Transaction as TSQLTransaction).Commit; if you
want