Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nice order to create
Message
De
18/03/2016 05:16:34
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
18/03/2016 05:11:51
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 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01633318
Message ID:
01633322
Vues:
63
The number of dots is not limited, at least not reasonable. :(
Also the user might alter the field (IOW append dot letter sections or change the whole thing). Thats why I like to have it as index expression - it would sort itself.

>create 3 virtual columns with the dot as separator, order columns on padl(evl(int(val()), 999),3). Then think about the last Item, AA ;-)
>
>
>
>>Hi everybody.
>>
>>I have a list with elements like
>>
>>1
>>10
>>2
>>03
>>1.1
>>12.R
>>1.1.R
>>1.R
>>1.R.1
>>A
>>B
>>AA
>>5.R
>>
>>I need to order (by indexing) this to
>>
>>1
>>1.1
>>1.1.R
>>1.R
>>1.R.1
>>2
>>03
>>5.R
>>10
>>12.R
>>A
>>B
>>AA
>>
>>any idea to do this, as fast as possible?
>>
>>Thanks
>>
>>Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform