I finally have my first testproject and have a problem. In most of my Projects I use a structure similar to this:
Code: Select all
ZConnection1.Connect;
ZConnection1.StartTransaction;
try
[do someting]
ZConnection1.Commit;
except
ZConnection1.Rollback;
end;
ZConnection1.Disconnect;
When the program subsequently tries to execute the rollback I get the exception "Invalid operation in AutoCommit mode".
Taking a look at the database, I see that the Transaction has been committed. But I wonder why the Connection would do anything to an inactive Query and why it does this after the commit?
This happens with the current version of http://svn.code.sf.net/p/zeoslib/code-0 ... es/testing as well as with the latest version of http://svn.code.sf.net/p/zeoslib/code-0/trunk on Delphi XE2 and Firebird 2.1. The transaction isolation level is set to tiReadCommitted.
Best regards,
Jan