Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing/sorting problem...
Message
 
 
To
18/01/2005 15:58:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00978295
Message ID:
00978313
Views:
23
>>I would create a table with two columns: Size C(5) and SortOrder I and use it for sorting. Another way is to store sizes in a string in proper order and use AT() as sortorder.
lcSizes = ",XS,S,M,L,XL,2XL,...,"
>>? AT([,] + ALLTRIM(size) + [,], lcSizes)
>>
>
>OK, I thought about it ;-)
>
>#1 - perfect long term solution, easy to implement.
>
>#2 - also perfect for this munging session.
>

You're welcome. :-)
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform