Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views and SEEK
Message
De
24/04/1997 10:01:46
 
 
À
23/04/1997 12:45:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00029325
Message ID:
00029535
Vues:
27
>>You can index a view. I also suggest that you check out a public domain grid class called INGRID that gives you incremental search capabilities in a grid.
>>
>>Craig
>
>It was I that asked about indexing a view the other day, and the response that I got was that no, you couldn't but you could base your grid on a table that was written at runtime from the view and then index that. This is impractical for me, as the view I need indexed is about 100.000 records. Is there another way?

100,000 records??? That seems like way too many to see in a view. A view is just like any cursor created with a SQL SELECT statement except that it is read/write. You should try to limit the number of records returned to the view.

Short of indexing, which is required to do a SEEK, the only other thing you can do is a LOCATE.

Craig
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform