-
Cancel Query
If I run a query in SQL Plus and it is taking too long to display the results, I have the ability to cancel the query in the middle of its process.
When running this same query in Visual Basic, is there a way to invoke this command when the query is in the middle of running. I want to allow the users to be able to cancel out of the process if it is taking to long.
Any suggestions??
Thank you!
-
Re: Cancel Query
set rs = conn.execute(strquery, , adasyncExecute)
Do until rs.state <> adstateExecuting
r = msgbox "Do you want to cancel?",vbyesno
If r = vbyes then rs.cancel
Loop
Iouri Boutchkine
[email protected]