Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek, seek(), indexseek()
Message
De
04/09/2002 18:21:34
 
 
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:
00696888
Vues:
10
>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.

Thanks for your answer

Certainly your solution is very useful in most cases, but what if I decided
to move to the record in case is found? what I wanted is your solution but in one indexseek()
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform