Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter to
Message
 
 
To
12/12/2001 09:02:43
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00593053
Message ID:
00593219
Views:
29
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform