RollBack not undoes the changes

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

Moderators: gto, EgonHugeist

Post Reply
doidopb
Fresh Boarder
Fresh Boarder
Posts: 9
Joined: 01.12.2012, 19:52

RollBack not undoes the changes

Post 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
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

doidopb,

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

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
Post Reply