Cancel Query

[rlecjr]

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!

[Iouri]

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
iouri@hotsheet.com