I can't have the control of transaction
Posted: 19.12.2005, 22:16
Hello,
I have a problem when a use StartTransaction with ZeosDBO on PostgreSQL 8.1. When I try to use TZConnection StartTransaction procedure with false AutoCommit propertie I receive "Invalid operation in non AutoCommit mode" exception. If I change AutoCommit to true, the exception doesn't appear, but when I StartTransaction and, for example, insert a row first and delete another row as a second operation, if the second operation cause an error, my first insert operation don't rollback.
Best regards,
François Oliveira
I have a problem when a use StartTransaction with ZeosDBO on PostgreSQL 8.1. When I try to use TZConnection StartTransaction procedure with false AutoCommit propertie I receive "Invalid operation in non AutoCommit mode" exception. If I change AutoCommit to true, the exception doesn't appear, but when I StartTransaction and, for example, insert a row first and delete another row as a second operation, if the second operation cause an error, my first insert operation don't rollback.
Best regards,
François Oliveira