is transaction file activated
lazarus / 16-Databases

----------------------------------------------------------------------
mangakissa · 2014-11-06 15:34

I'm converting my application from 1.2.0 to 1.2.6. I noticed
TSQLTransaction.transaction is now working. All my transactions were
set on caCommitRetaining. But not usefull, because en
TDatamodule.destoy I will look for open tables, commit the transaction
and close the table. I have to set TSQLTransaction.transaction to
caNone, because I get troubles with caCommitRetaining.

1. is there a way to check is transactive is really active (I assume
TSQLtransaction.active)?
2. Can a check build into TSQLTransaction.transaction if transaction
is already closed?

----------------------------------------------------------------------
goodname · 2014-11-06 20:26

Generally transactions are automatically started by opening a query.
It can depend on the database implementation on when the transaction
ends.
There is a TSQLTransaction.active property.
Do not know what a TSQLTransaction.transaction is. As far as I know
there is no such property.

----------------------------------------------------------------------
mangakissa · 2014-11-07 07:35

Correction. Should be TSQLTransaction.action