I have an ODBC connection to a sybase 11 server. I am using SQLexec() to send a pass-through 'select' statment to retrieve some data. I would like users to be able to press a cancel button on the form if they want to stop the query.
I use SQLsetprop() to switch to asynchronous mode and then use a simple 'do while .. enddo' look to run the query via SQLexec. How can I check to see if a user has tried to press the cancel button ?

I am really stuck with this one and would appreciate any help!!

Alec.