Transaction Commit

[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

[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

[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