请问用几个AdoTable同时插入数据，怎样实现Sql的事务控制？

Question

请问用几个AdoTable同时插入数据，怎样实现Sql的事务控制？

Answer 1

try
adoconn.begintrans
adotable.update
adotaben.update
adoconn.commitrans
except
adoconn.rollback;
end;
具体的语法单词可能不对，你查查

Answer 2

begin
   ADOConnection1.BeginTrans;
   try
      //...
      // ...
      ADOTable1.Post;
      //...
      //...
      ADOTable2.Post;
      //...
      ADOConnection1.CommitTrans;
   except
      ADOConnection1.RollbackTrans;
   end;
end;