Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEXing UPPER(cField)
Message
From
23/06/2006 03:05:10
 
 
To
23/06/2006 02:33:11
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01131030
Message ID:
01131039
Views:
10
>When creating an index i doing this...
>
>INDEX ON UPPER(cfield) TAG TAG1
>
>but I'm not getting the expected result.
>
>when I do SEEK("mykeyvalue"), in lower case, it can't find it. Why... am I not doing something right?
>
>I know the value ("MYKEYVALUE")exist.
>
>TIA

When you ask for rice, don't expect potatoes! :-)
Try SEEK(upper("mykeyvalue")) or SEEK("MYKEYVALUE"). Or change the index expression to lower(cfield).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform