Why not just do a SQL SELECT?
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer