Thank you for the feedback.

>Sounds ok to me...
>
>>Hi all,
>>
>>Is this the correct implementation of FetchAsNeeded? See comments.
>>

>>dbsetprop("cConnName","connection","asynchronous",.t.)
>>cursorsetprop("FetchSize", 50, 0)
>>cursorsetprop("MaxRecords", 50, 0)
>>cursorsetprop("FetchAsNeeded", .t., 0)
>>* assume this query takes 10+ seconds to run, I want to display
>>* the grid at once with the first 50 rows and 'fetch' the remaining data
>>* in the background.
>>nLocID = 12345
>>cSQL1 = "select "+;
>>           "a.itemid,b.locname,a.yearweek,c.skustat, d.itemname, e.supplier "+;
>>        "from "+;
>>           "dailysales a, locs b, sku c,items d, suppliers e "+;
>>        "where "+;
>>          "a.locid=b.locid "+;
>>          "and a.itemid=c.itemid and a.locid=c.locid "+;
>>          "and a.itemid=d.itemid "+;
>>          "and d.suppid=e.suppid "+;
>>          "and a.locid=?nLocID "
>>create sql view (cViewName1) remote connection (cConnName) shared as &cSQL1
>>use (cViewName1) in 0 alias (cViewAlias1)
>>* will VFP continue processing the following lines of code
>>* even before all the records in cViewName1 are "fetched".
>>* this is just a view that will be a "child" of the current record of the above view.
>>create sql view (cViewName2) remote connection (cConnName) shared as &cSQL2
>>use (cViewName2) in 0 alias (cViewAlias2) nodata && note: nodata keyword
>>

>>
>>These queries are for the purpose of explaining my question. Assume that the queries
>>will work.