>>How can I increase the SET FILTER command performance? When I use the SET FILTER in a large table the filter speed is very slow. Anyway I can boost the speed?
>>
>>Thanks, Tai Fei Pao
>
>That would depend under what circumstances you want to use SET FILTER. One big problem for many users is when a filtered table is used in a grid. This should be avoided; instead, you should use a parameterized view.
>
>Another example: For processing data without user interaction, you might select an index - SET ORDER TO ... - followed by a SEEK(), and a DO WHILE.
>
>Also, in many cases you can use a query (if you don't need to modify the data).

That is my problem. I used a filtered table in a grid. Now I know I need to reprogram. Thanks a lot.

Tai Fei Pao