>>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.
This sounds great. However, I run your program (added some code to resolve file is in use error, no where in sql at all) , edited the cursor using browse command but base table was not changed!!
It seems that I edited only temporary table. How it is possible
to change cursors base table in this way !? How I can make true cursor?
Andrus