Android RollBack Problem

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
siberya
Posts: 23
Joined: Thu 23 Mar 2006 19:00

Android RollBack Problem

Post by siberya » Sat 07 Apr 2018 02:38

My experiment on Android is using myDac. in the following code block, if there is an error in the post operation, is not the deleted record rollback?

Where am I making mistakes.

Thanks.

try
MyCon1.StartTransaction;
myQuery1.SQL.Text := 'delete form xtable where id = 1';
myQuery1.Execute;

Table1.Edit;
Table1.FieldByName('Field1').AsInteger := 'XXXX';
Table1.Post;

MyCon1.Commit;
except
MyCon1.RollBack;
end;

ViktorV
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: Android RollBack Problem

Post by ViktorV » Wed 11 Apr 2018 15:10

Unfortunately, we cannot reproduce the issue on the latest version MyDAC 9.1.5.
Please check whether the problem occurs on the latest version MyDAC 9.1.5 and if yes, to investigate the specified MyDAC behavior, please compose a small sample demonstrating the issue of test access to your server and send it to us via e-support form: https://www.devart.com/company/contactform.html, including database objects creating scripts.
Also please specify the exact versions of the used MyDAC, MySQL server, Android and IDE.

Post Reply