Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek Command
Message
De
09/06/1999 13:25:30
 
 
À
09/06/1999 11:45:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00227920
Message ID:
00228004
Vues:
17
>Does anyone know how I can do an extensive seek. Something like:
>Seek (birthd) and patname.value = tablename.fieldname and etc etc

Use LOCATE rather than SEEK, which can use existing indexes to fully or partially optimize an expression involving multiple fields, each having its own tag. This will spin through the file in the current index order.

or if you have a few fixed composite lookups create index tag(s) based on multiple fields; generally, this will involve concatenating string values together to create the index; something like:

INDEX on DTOS(birthdate)+some character field TAG ComplexNDX

Now, to do a lookup:

SET INDEX TO ComplexNDX
SEEK DTOS(birthd) + pathname.value

This will order things by the complex expression.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform