Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index On a description field with upper/lower case
Message
From
05/01/1999 11:01:11
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00172769
Message ID:
00172773
Views:
20
>Have a description field with mixed case in the table. There is an index on the description field. Some descriptions are all upper, some are all lower. When I show the descriptions in a list box, upper case sorts to the sop, then lower case.
>
>Would like the list box to show the descriptions in order regardless of upper/lower case. What can I do?
>
>Thanks - Brenda

Probably, you should fill the listbox with appropriately changed descriptions:
***Listbox.Init event
Select MyTable
Scan
 This.AddItem(PROPER(MyTable.Description))
EndScan
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform