Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEXing UPPER(cField)
Message
From
23/06/2006 09:15:53
 
 
To
23/06/2006 09:06:47
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:
01131116
Views:
21
You're welcome, it happens to everybody! :-)

>Thanks Tore I saw my flaw shortly after I posted.
>Brain fart.... :)
>
>Thanks again.
>
>
>>>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
Reply
Map
View

Click here to load this message in the networking platform