>Searching data with set filter and sql select works at same speed I think.
>
>However, searching data with set filter and grid works very slowly,
>since grid refresh seems not to use rushmore optimization with set filter,
>it likes to scan all records (seems to be bug also noted in the visual extend manual but not in any other places).
>
>"browse for
" works also fast, since it uses rushmore, but this is not oop.
>
>So my problem is to find a alternate way to set filter + grid control for
>arbitrary search expression. set key needs pre-determined search expression,
>create sql view scans whole base table.
>There seems no way to do it and i'm very unhappy.
But Andrus I didn't say to do it with view. A true cursor would only hold the subset (SQL select is as fast as a filter) and be editable. It would be like a buffered table with only subset records. No expression to reevaluate with rec movement and small in size.
Cetin