Hi!

This is because such feature just not implementable with SPT. Many times it was asked in many forums, mostly in form of "Is ot possible to display aprogress of SPT cursor loading?", and no answer. Asynchronous connection will not help - cursor is still downloaded all at once. "Asynchronous" means that SQL commands run while VFP program continue running. As soon as VFP gets the result, VFP does not continue till the entire record set is downloaded.

You can split records to parts and download them as segments.

You can create the remote view - they have (!) a FetchAsNeeded property that is exactly what you're asking for.


>>You can probably use an Asynchronous connection. That way, SQLExec will come back inmediatly and your browse will show up quickly.
>
>>HOWEVER (big HOWEVER <g>) working with asynchrounous connections is not as easy as it sounds. With an asynchronous you will need to be looping (probably in a timer) asking VFP if it has finished downloading records while the user is still browsing records.
>
>>Also, I have found scenarios where VFP does not work asynchronous (and thus the user needs to wait) even when the connection is asynchronous.
>
>>Anyway, you can problably play with it and see if it does what you need.
>
>Yes, I've tried setting SqlSetProp (nSQLHandle, "Asynchronous", .T.) and implement a cursor "fill" loop before, but couldn't make it work properly. What I'm needing is the exact statement sequence to do it. In all books I have and in the MF VFP 6.0 manuals I couldn't find an answer to my problem.
>
>Thanks,
>
>Fernando