Hi!

James, this is because you usd common (SHARED) connection fro all views. Each remote view with FetchAsNeeded option should have separate connection, so "SHARED" option for such views should be switched off to do not get mentioned error. Of course, too much views of such kind will cause overuse of connections whne you have a lot of workstations.

>Seems to me that I tried FetchAsNeeded once and it gave me conncection busy errors untill the entire data set was fetched. I had to use a seporate connection to make it work.
>
>
>>You are right, I mixed both concepts! FetchAsNeeded will do the trick.
>>
>>
>>>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