Page 1 of 1

RollBack not undoes the changes

Posted: 30.06.2013, 18:22
by doidopb
Hello to all ...

I use Zeos with MYSQL in my Delphi applications with MYSQL 5.0.45.

After much searching, I finally found out why RollBack in my ZeosConnection never undoes the changes when i explicitly start the transaction with StartTransaction. This occurs when the ZConnection is TransactionIsolationLevel configured to tiNone.

Why does this happen??

Thanks

Posted: 03.07.2013, 06:30
by EgonHugeist
doidopb,

tiNone = no Transaction, so Zeos-Commits allways. change TransactionIsolationLevel to tiReadCommited. Or set TZConnection.AutoCommit := False;