Users want to edit the queried records, selecting into cursor
does not allow this. How to allow them to edit queried data in a grid?

I think the problem is that set filter is rushmore optimizable,
but set filter + grid is not rushmore optimizable (grid refresh will
not use ruhmore for some reason)

>I guess I'd try converting their query input into a SELECT instead of a filter and create a cursor. Fox will have to scan the whole table for either a filter or a select unless there are indexes to support rushmore optimization. I've never had to be concerned about Fetchsize so I don't have any recommendations there.
>
>>Users can construct an arbitrary query from
>>large single table using query builder.
>>
>>Parametrized view cannot be used in this case since foxpro scans
>>the WHOLE BASE table, when query returns many rows and this takes
>>TOO long time. It is stange that Fetchsize parameter seems not
>>to work !? It must work with local views also ccording to fox doc.
>>
>>Linkmaster property requires that there must be a parent table and
>>existing index in child table.
>>I don't have a parent table (it is strange to create dummy one for
>>query). Also, for user-defined arbitrary filter contition it is not possible
>>to pre-determine reasonable index in child table.
>>
>>So it seems that there are no solution at all.