set cnn=new adodb.connection
cnn.open cnnstringset rst=new adodb.recordset
rst.open .....
rst.movefirstcnn.begintrans '事务处理开始
.........
rst.update
cnn.committrans '提交事务处理rst.close
cnn.close
cnn.open cnnstringset rst=new adodb.recordset
rst.open .....
rst.movefirstcnn.begintrans '事务处理开始
.........
rst.update
cnn.committrans '提交事务处理rst.close
cnn.close
set cnn=new adodb.connection
cnn.open cnnstring
on error goto HandError
cnn.begintrans '事务处理开始
.........
rst.update
cnn.committrans '提交事务处理
cnn.close
exit sub
HandError:
cnn.close
cn.begintrans
....
if ....
cn.rollbacktrans
end if
....
cn.committras
cnn.open cnnstring
on error goto HandError
cnn.begintrans '事务处理开始
.........
rst.update
cnn.committrans '提交事务处理
cnn.close
exit sub
HandError:
cn.rollbacktrans
On Error Goto ErrRowoCon.BeginTrans
fRet=oCon.Delete
fRet=oCon.Add
...
If fRet=False Then Goto ErrRow
oCon.CommitTrans
MsgBox "OK!"
Goto EndRow
ErrRow:
oCon.RollbackTrans
Msgbox "Failed"
EndRow:
Set ..=Nothing
End Sub
还是老老实实的用sql语句吧