>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.
Hi,
On the Click of your cancel button you could set a global variable, or a form level property, then in you DO WHILE expression you could check the value to see if the query has finished OR the user pressed cancel.