>When you execute an asychronous query you only need to wait for enough data to display on your form. FoxPro will grab records in blocks. The number of records in a block is determined by your "Records to Fetch at a Time" setting on the "Remote Data" tab in Tools/Options. You can also set this using CURSORSETPROP("FetchSize", nSize) or if you are using a remote view DBSETPROP(cViewName, "VIEW", "FetchSize", nSize). Specifying -1 for the FetchSize retrieves all the records at once (or MaxRecords if that is set). If you want to wait for all the records I'd set Asynchronous to .F. You can set this using SQLSETPROP(nConnectionHandle, "Asynchronous", lTrueFalse). To set this for the FoxPro default use 0 (zero) as your connection handle (this is the same as setting it in Tools/Options).
Thanx for the response. This has all been extremely informative but I still have the original problem: How do I stop the "Executing Remote... Press ESC to cancel." message from appearing? It shows up no matter how I set the Asynch mode or the fetch size. Any ideas? thanx again!
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
