Devart Forums

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;

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.