Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with seek on a view
Message
De
21/08/2000 13:52:26
 
 
À
21/08/2000 13:46:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00407408
Message ID:
00407427
Vues:
24
>>Yes it does. If you use both ORDER and then TAG, the seek command looks for an index called TAG. Try it.
>
>create table testorder ('field1' c(10))
>index on upper(field1) tag testseek
>seek 'Test' order tag testseek

>
>No errors there, I'm not sure what you mean.

Woopsy. You're right. It would help my testing practice if I tested with a tag that really existed. I had tested with the equivalent of the following:

create table testorder ('field1' c(10))
index on upper(field1) tag testseek
seek 'Test' order tag testorder

Sorry, Jimmy.

I would go with Mike's first suggestion: ensure that the alias is current before issuing your SEEK, or better yet, use the IN clause.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform