使用类事件 1.用WithEvent申明Connection。 2.创建该Connection对象。 3.分别处理该对象的CommitTransComplete、RollbackTransComplete事件。 例如: Dim WithEvents connEvent as Connection Dim conn as New ConnectionPrivate Sub MySub() set connEvent = conn ' Enable event support. conn.Open(...) ... set connEvent = Nothing ' Disable event support. ... End SubPrivate Sub connEvent_ConnectComplete(ByVal err as ADODB.Error, & _ adStatus as ADODB.EventStatus, ByVal pConnection as ADODB.Connection) ' Check the error object only if adStatus ' equals adStatusErrorsOccurred. ... End Sub
ReLevel = fxConn.BeginTrans
If ReLevel > 0 Then
‘开始了
End If
1.用WithEvent申明Connection。
2.创建该Connection对象。
3.分别处理该对象的CommitTransComplete、RollbackTransComplete事件。
例如:
Dim WithEvents connEvent as Connection
Dim conn as New ConnectionPrivate Sub MySub()
set connEvent = conn ' Enable event support.
conn.Open(...)
...
set connEvent = Nothing ' Disable event support.
...
End SubPrivate Sub connEvent_ConnectComplete(ByVal err as ADODB.Error, & _
adStatus as ADODB.EventStatus, ByVal pConnection as ADODB.Connection)
' Check the error object only if adStatus
' equals adStatusErrorsOccurred.
...
End Sub
BeginTransComplete事件是在事务开始后调用。可以在这里判断。