RollBack not undoes the changes

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Fresh Boarder
Fresh Boarder
Posts: 9
Joined: 01.12.2012, 19:52

RollBack not undoes the changes

Postby doidopb » 30.06.2013, 18:22

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??


User avatar
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 03.07.2013, 06:30


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

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude!


Return to “6.6 - stable”

Who is online

Users browsing this forum: No registered users and 1 guest