Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing/sorting problem...
Message
 
 
À
18/01/2005 15:16:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00978295
Message ID:
00978298
Vues:
23
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform