TZConnection::AutoCommit

jjeffman · Post by **jjeffman** » 29.11.2005, 14:05

I would like some information on how to control the database transactions using the TZConnection Zeos component.
I might be wrong but for me is a very strange behavior having to set up AutoCommit to true for calling StartTransaction, Commit and Rollback. All other components I have been working with use the AutoCommit set to true when you do not want to control the transaction by yourself.

When will the Help files or documentation on Zeos Database components be available ?

skozan · Post by **skozan** » 30.11.2005, 15:35

With AutoCommit set to True, every SQL statement is (auto)commited. When StartTransaction is executed then all statements are executed on the Commit.

jjeffman · Post by **jjeffman** » 30.11.2005, 20:36

The way you described is just the way I use with other database components like ODAC (www.crlab.com) . If you have a look at the code of the TZConnection component you will see that you "must" be in auto-commit mode to call the StartTransaction method. That is what seems to me very strange.

darkbrain · Post by **darkbrain** » 28.12.2005, 12:53

Yes it's strange also for me, and the lack of documentation doesn't help. Anyway this article helped me: http://seegernet.koolhost.de/zeosforum/ ... rticle&k=6
when i start a manual transaction it's turned off automatically.
In practice Autocommit can't be false, so why is here?

bye,
DarkBrain