Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing/sorting problem...
Message
 
 
To
18/01/2005 15:16:02
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:
00978298
Views:
25
This message has been marked as the solution to the initial question of the thread.
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)
>I'm in a data munging session, and this appeared a good time to ask.
>
>When using apparel sizing, my mind has no problem seeing XS, S, M, L, XL, 2XL, ... as fitting and proper. Any ideas on how to get this computer to think like I do?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform