Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set filter to
Message
 
 
À
12/12/2001 09:02:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00593053
Message ID:
00593219
Vues:
32
This message has been marked as a message which has helped to the initial question of the thread.
>I do have a UPPER(LastName) index in my table.
>For some reason rushmore doesn't work in this case and I still havn't found the reason why.
>
>I tried it with a view it's doing the exact same thing...
>The strangest thing is that it only take to long in certain searches and not all.

In order for Rushmore to work the left side of you filter expression must exactly match an index expression. In you case
* The index expression 
UPPER(LastName) 
* The filter expression should be 
SET FILTER TO UPPER(LastName) = < ... > 
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform