I'm trying to do a few command to update some data.
As some of them can be done simultaneously (they won't affect the same records), I'd like to use the adExecuteAsync so I can fire several one quickly and simply wait until they are all finished.
The problem is that VB doesn't recognize "adExecuteAsync", telling me that my variable has not been declared...
I am using VB6.0 (learning edition), ADO 2.6 along with the default references (VBA, VB runtime, VB objects and procedure, OLE automation) on Windows XP pro.
My code looks something like this:
Set cmdTest = New Command
cmdTest.ActiveConnection = cnnConnection
cmdTest.CommandText = "DELETE FROM MyTable"
cmdTest.Execute , , adexecuteasync
'cnnConnection.Execute("DELETE FROM v2flcalldata", , adexecuteasync)
While cmdTest.State = adStateExecuting
' WAIT FOR IT TO FINISH
What have I done wrong?