Android RollBack Problem
Posted: 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;
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;