Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fast Rushmore optimized filtering in grid controls
Message
From
28/02/2004 15:25:14
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00881790
Message ID:
00881809
Views:
24
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
Previous
Reply
Map
View

Click here to load this message in the networking platform