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)
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)
create sql view (cViewName2) remote connection (cConnName) shared as &cSQL2
use (cViewName2) in 0 alias (cViewAlias2) nodata
These queries are for the purpose of explaining my question. Assume that the queries
will work.
ramil
~~ learning to stand still