Hi!

Demetrius, you're not alone in your frustration ;)
Asynchronous query used to run query on the server asynchronously. This means: you send query, server compiles it (if it is not SP), runs (this may take some time for complex query), prepares result than waits for second request from client. When query result is not ready, server returns 0. When result is ready, server sends it. However, no matter how long is result set, you will receive it all at once, so when you want to cancel downloading of megabytes of data, you cannot.
Another way to query data is non-batch mode. In non-batch mode query result split and sent to client in packages. Your equire to run SQLPrepare, than SQLExec as many time as server retuns results. The problem is that you will have in such case multiple cursors, each cursor for each non-batch query result. You will require to use copy to command locally to join all these results into a singlke record set. Remote views, however, have built-in ability to download next bunch of data just into the same cursor, that is quite wondering - why not make the same feature for SPT cursors?
You also can use both methods to take benefits of both.

>I have tried several times to decipher how to get SQLEXEC to work asynchronously but failed. I have tried the SQLSETPROP and failed. I simply want to submit an SQL statement to Oracle back end and then while the user is waiting for the query to begin the download - to be able to abort the query.
>
>If anyone has an SQLEXEC method to handle all the permutations that I can't figure out, I would be very grateful. If I have to look at that stupid VFP manual one more time WRT async, I will spontaneously explode.