Suppose you have the following code:
try
ADOConnection.BeginTrans;
MasterTable.UpdateBatch;
RelatedTable.UpdateBatch;
ADOConnection.CommitTrans;
except
ADOConnection.RollbackTrans;
end;
If something fails (transaction rolls back): can I reapply UpdateBatch? Are
cached updates lost?
Thanks!
.
Updatebatch question ... If something fails (transaction rolls back): can I reapply UpdateBatch?... (borland.public.delphi.database.ado)
Re: Updatebatch question ... >If something fails (transaction rolls back): can I reapply UpdateBatch?... If RelatedTable.updateBatch fails you can't just reapply MasterTable batch. ... (borland.public.delphi.database.ado)