Article ID: 172239
Article Last Modified on 11/7/2003
Set rs = cn.OpenResultset("select * from Authors", _
rdOpenKeyset, rdConcurValues)
DoEvents
If you use the OpenResultset method with the rdAsyncEnable option, you need
to use the following code to workaround the problem:
Set rs = cn.OpenResultset("select * from Authors", _
rdOpenKeyset, rdConcurValues, rdAsyncEnable)
While rs.StillExecuting
DoEvents
Wend
DoEvents
Private WithEvents cn As rdoConnection
Private Sub cn_QueryComplete(ByVal Query As RDO.rdoQuery, _
ByVal ErrorOccurred As Boolean)
MsgBox "Query Done --> From QueryComplete Event."
End Sub
Public Sub QueryCompleteTest()
Dim rs As rdoResultset
Set cn = New rdoConnection
With cn
.Connect = "UID=<username>;PWD=<strong password>;database=pubs;" _
& "Server=ServerName;" _
& "driver={SQL Server};DSN='';"
.QueryTimeout = 5
.CursorDriver = rdUseClientBatch
.EstablishConnection rdDriverNoPrompt
End With
Set rs = cn.OpenResultset( _
"select * from Authors", _
rdOpenKeyset, rdConcurValues)
'DoEvents
End Sub
Private Sub Command1_Click()
Dim ClsQuery As New Class1
ClsQuery.QueryCompleteTest
End Sub
Additional query words: kbVBp500 kbVBp600 kbdse kbDSupport kbVBp kbVBp400 kbRDO
Keywords: kbbug KB172239