Link to home
Start Free TrialLog in
Avatar of whitelotus
whitelotus

asked on

ADO, adAsyncExecute

any one have example how to execute storedprosedur in ADO connection adAsyncExecute option ??
i need to give animasi to my from when waiting storedprosedure done.

Thanks.
Avatar of sharmon
sharmon
Private Function Test()
  Dim objCmd As ADODB.Command
  Set objCmd = New ADODB.Command
 
  With objCmd
    .ActiveConnection = "DSN=YourDSN"
    .CommandTimeout = 180
    .CommandText = "YOUR_SP"
    .CommandType = adCmdStoredProc
    .Execute , , adAsyncExecute
  End With
 
  Do While (objCmd.State And adStateExecuting) = adStateExecuting
    DoEvents
  Loop
 
  Set objCmd = Nothing
End Function
ASKER CERTIFIED SOLUTION
Avatar of sharmon
sharmon
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sharmon
sharmon
If it wasn't want you wanted, you didn't need to close the question, you should have responded with whatever you might have needed.

Shannon
Avatar of irman_herdiana
irman_herdiana
am using that method, but it's seem make my application crash,  it happened when am add the skinframwork from codejock activex..does fall because the sync method or bug in codejock activex?