troubleshooting Question

adExecuteAsync not recognized

Avatar of FraggleRock
FraggleRockFlag for United Kingdom of Great Britain and Northern Ireland asked on
Visual Basic Classic
5 Comments1 Solution602 ViewsLast Modified:
Hi guys,

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
Wend


What have I done wrong?

Thanks
ASKER CERTIFIED SOLUTION
Nitin Sontakke
Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros