Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Fast Rushmore optimized filtering in grid controls
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement