Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek, seek(), indexseek()
Message
 
 
À
04/09/2002 17:30:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00696857
Message ID:
00696864
Vues:
13
Roman,

I'm not sure if this is what you are looking for, but assuming indexes exist
if ( ( indexseek( TableA,Field1, .f., "LookupB", "FieldXTag" ) and ;
     ( indexseek( TableA,Field2, .f., "LookupC", "FieldYTag" ) and ;
     ( indexseek( TableA,Field3, .f., "LookupD", "FieldZTag" ) )
you can AND/OR the results of individual indexseek()s together. This would make sure that TableA.Field1 is found in LookupB.FieldX and TableA.Field2 is found in LookupC.FieldY and TableA.Field3 is found in LookupD.FieldZ. It's also possible to lookup different fields within the same lookup tables.

>Is there a way I can use SEEK, SEEK(), INDEXSEEK() for finding a record that must matches the value of several fields without using '+' to join fields in the expresion of the index?
>if it is possible, could you an example.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform