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.
i need to give animasi to my from when waiting storedprosedure done.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Shannon
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?
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