调试时在With rsuser
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Open "person", cnlocal(出错)
End With
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Open "person", cnlocal(出错)
End With
就是在下面的过程中添加参数,
改
Private Sub Class_Initialize()
为
Private Sub Class_Initialize(byval mycon as ADODB.Connection)
然后在实例化的时候,传递cnlocal给类实例
如果类与公共模块不再同一工程,则要再定义一个方法将connection对象传进去才行。如定义一个
public sub InitClass(myconn as connection)
Set rsuser = New ADODB.Recordset
With rsuser
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Open "person", myconn
End With
end sub
生成类实例后,再调用这个方法就可以,
例:
MyClass.initClass cnlocal
注意这一句一定要放在打开连接的后面