>Perhaps. The other issue with filters and grids is the scroll bar does not work as it should. I use parameterized views. IMHO, it's a much more sublime solution.
Depends on the view and the parameters:
http://msvfp.advisorguide.com/doc/16302SPT with dynamically constructed ad-hoc parameterized where clauses is IMO the ultimate in control for me as a developer, flexibility for the user, performance and safety.
>
>>VFP 9 Help says following:
>>"When using SET FILTER to filter data in a grid, use the SET KEY command to increase grid performance."
>>Does it indicate that performance problem still exists?
>>
>>>I haven't used filters for a table of any significant size in ages. Love those parameterized views. However, I could swear that I recently came across something that was saying that in VFP 9 (or whatever it said - a recent version) the filters were now very fast and this made them useable again. Wish I could remember where I saw that (or perhaps I was hallucinating). Have you heard anything like that (I guess not based on your reply).
>>>
>>>>Then this is your problem. Grids and filters don't agree with each other. In fact, SET FILTER command is obsolete and should not be used at all. Look into parameterized view or CA solutions instead.