|
| Is there any way to show the progress and cancel from a 'requery()' on a
remote view that may return a large record set.
When I set CURSORSETPROP("MaxRecords",100,ctable) to limit the number of
records returned (10,000 may records match the view parameters), It seems to
take just as long as when is set MaxRecords to -1, there are just only 100
records in the cursor (view) after the requery() completes.
connection props as follows:
async = .f.
batch = .t.
autotrans = .t.
packed size 4096
view props as follows:
DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.F.)
DBSetProp(ThisView,"View"," AllowSimultaneousFet
ch",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","workordr")
DBSetProp(ThisView,"View","WhereType",1)
(vfp 9.0)
|
|