Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speeding up a lookup with a large character field
Message
 
 
À
11/02/2002 18:57:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00618638
Message ID:
00619039
Vues:
11
The INDEXSEEK managed to speed it enough that I might be able to get away with not hashing the index. I'll keep Gregory's code around, though, just in case.

Thanks, both of you,

Michelle


>Michelle,
>
>... provided you are on the source table to search...
>
>lfound=INDEXSEEK(whatIwant, .T.)
>
>IF lfound
> .... get the file stuff you want... the record pointer has moved there...
>ENDIF
>
>See HELP for INDEXSEEK()
>
>HTH
>
>Ric
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform