lz是指数据库的事务控制?'先打开数据库连接conn Err.clear conn.BeginTrans '插入、更新操作 conn.execute "insert into table1(col1,col2) values(value1,value2)" conn.execute "update table2 set co11=value1,col2=value2" if Err then conn.RollbackTrans'回滚 else conn.CommitTrans'提交更新 end if conn.close set conn=nothing
Err.clear On Error GoTo Errhandle
cn.BeginTrans '开始事务 '插入、更新操作 cn.execute "insert into table1(col1,col2) values(value1,value2)" cn.execute "update table2 set co11=value1,col2=value2" cn.CommitTrans '提交事务
Dim cnn As New ADODB.Connection ... ... cnn.BeginTrans '开始新事务 cnn.Execute sql If cnn.Errors.Count > 0 Then cnn.RollbackTrans MsgBox "建立数据库时出错,检查磁盘空间是否太小,重启计算机,再试。" Exit Sub Else cnn.CommitTrans End If
Err.clear
conn.BeginTrans
'插入、更新操作
conn.execute "insert into table1(col1,col2) values(value1,value2)"
conn.execute "update table2 set co11=value1,col2=value2"
if Err then
conn.RollbackTrans'回滚
else
conn.CommitTrans'提交更新
end if
conn.close
set conn=nothing
cn.BeginTrans '开始事务 '插入、更新操作
cn.execute "insert into table1(col1,col2) values(value1,value2)"
cn.execute "update table2 set co11=value1,col2=value2"
cn.CommitTrans '提交事务
Exit Sub
Errhandle:
cn.RollbackTrans '回滚事务
End Sub
Dim cnn As New ADODB.Connection
...
...
cnn.BeginTrans '开始新事务
cnn.Execute sql
If cnn.Errors.Count > 0 Then
cnn.RollbackTrans
MsgBox "建立数据库时出错,检查磁盘空间是否太小,重启计算机,再试。"
Exit Sub
Else
cnn.CommitTrans
End If