有两种方法
________________________________
1.
cn.execute "begin tran"
...
...
'中间的过程必须都是这个cn用execute发送的sql命令.
...
cn.execute "commit tran"
or
cn.execute "rollback tran"2.
cn.begintrans
...
...
'中间都是用rs的操作
...
cn.committrans
or
cn.rollbacktrans
________________________________
1.
cn.execute "begin tran"
...
...
'中间的过程必须都是这个cn用execute发送的sql命令.
...
cn.execute "commit tran"
or
cn.execute "rollback tran"2.
cn.begintrans
...
...
'中间都是用rs的操作
...
cn.committrans
or
cn.rollbacktrans
如:
on error goto Err_Exit:
cn.begintranscn.committrans
Err_Exit:
cn.rollbacktrans