When combining a filter with a grid (in VFP 6), I got very poor performance. To get a subset of data, I used parameterized views, with excellent results. Mind you, this was based on one specific field, though; for the common requirement of editing all child records for a specific parent record.
>I have a VFP8 application that includes grid controls on forms that are bound to a table that has 4 million records and is over a gigabyte in size. The grid controls work very well for users to view and edit the data.
>
>While the users can find their data easily with a SEEK command, I would like to add the ability to filter the data based on a user specified criteria.
>
>Obviously SET FILTER is out of the question with a table of this size, but at the command prompt a simple BROWSE FOR table.field = "xyz" for the commonly needed filtering works very well with the indexes that I have.
>
>Is there an way to get the same Rushmore optimized filtering in a grid control?
>
>Thanks,
>Jeff
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
