I can't have the control of transaction

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
fdoliveira
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 18.11.2005, 15:40
Location: Caicó/RN

I can't have the control of transaction

Post by fdoliveira »

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
Post Reply