Instead of a DO WHILE loop, display a modal form with a cancel button and a timer. The timer will check to see if the query has completed. You can experiment with intervals until you find one you like. The cancel button will be available to the user between execution of the timer event.
>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.