Jayesh,

The connection property is set to synchronous. I don't understand why vfp doesn't wait until the data retrieval is truly finished before it ends the use command or requery(). I'm not sure what the point is of setting it to synchronous if it behaves this way. I must be missing something.



>Check "Asynchronous Execution" property of the connection on which the Remote View is based on. It should NOT be checked. This will retrieve all records in one shot.
>
>>I have a sql server table with 85K rows, a sales order line item file. Unfortunately for this application, it is difficult to come up with parameter conditions to limit the # of rows to retrieve - it makes more sense to download the whole file for the application I am working with.
>>
>>In my testing, when I open the view with the use command, it takes about 3 minutes for the view to 'fully open'. What I mean by that is that when I look at the progress on the status bar, it doesn't show the full record count for 3 minutes. In other tests, if I attempt any type of io operations such as skip or replace, before the view is 'fully loaded', execution pauses on the line, forever, and/or gives me a connection is busy error.
>>How can I 'test if the view is ready for processing', without generating the connection busy error? For example I have code similar to the following
>>
>>use v_sostrs
>>** need to put in some some kind of wait/loop test for view being ready
>>** or the same after a requery
>>go top
>>do while not eof()
>>
>> REPLACE SOMEVALUE IN V_SOSTRS &&hangs or times out connection is busy
>> SKIP
>>enddo
>>
>>If I execute lnresult=sqlexec(lnhandle, 'select * from sostrs','cursostrs')
>>It takes about 6 seconds to download 85K rows. Thereafter I can perform any io operation on the cursor that I want.
>>
>>why is there such a dramatic difference here? Is it possible to make the cursor created with sqlexec(lnhandle, 'select * from sostrs','cursostrs')updatable?
>>
>>Am I missing something simple or obvious, or not testing correctly?
>>
>>Any suggestions would be appreciated
>>
>>TIA