I am using a grid based on local view.
Local view is based on table having many records and returns all the records.
Prb: Local view creation scans ALL the records from base table and
this works VERY slowly! So it is not possible to use local views
for large data manipulation!? Fetchsize works for remote views only.
If I use table-based grid instead of view, it appears immediately,
if there are many records returned from table. But when filter condition returns only a few rows, table-based grid causes FoxPro to
hang, but browse command works. Since there are many different queries, I cannot pre-build a index for table.
So it is not possible to use table-based grid also!
So, it is not possible to use grid control at all for large data manipulation!
Andrus