Page 1 of 1

Transaction Commit

Posted: 07.12.2009, 12:27
by nico.callewaert
Hi,

I was wondering if AutoCommit of TZConnection is set to True, if the transaction is really committed of if it is a CommitRetaining? I would like that all transactions are committed and ended. Do I have to set AutoCommit = False and do a ZConnection.Commit in code after each update, or AutoCommit = True will do the job just fine ?

Many thanks in advance,

Nico Callewaert

Posted: 11.12.2009, 21:12
by mdaems
Hoi Nico,

Autocommit= True is almost exactly the same as just adding a commit after every statement. When you check the 'interbase' units in the dbc layer you'll see a commit is added after every call sending sql to the server.

Mark

Posted: 15.12.2009, 09:40
by nico.callewaert
Hallo Mark,

Many thanks for the reply. That is excatly what I was looking for !
The components work great with Firebird. Performance is fabulous.

Thank you !!
Regards,
Nico