RollBack not undoes the changes

[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

[EgonHugeist]

doidopb,

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