Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sort
Message
From
04/07/2005 10:30:49
 
 
To
04/07/2005 01:53:15
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Sort
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01028595
Message ID:
01028788
Views:
14
>hi,
>thank you for reply,
>i see the result is..
>1.5xzzwa19
>1c/xw.501f.....after index it must be
>------------------------------
>1c/x...
>1.5x.....
>----------------------------
>if i have ex..
>100a
>11a
>10a
>1a....after index it must be
>----------------------
>1a
>10a
>11a
>100a


Your sorting scheme is non-standard (e.g. not ASCI indexing) as you want
1a
10a
11a
100a
In that case unfortunately you would have to add another field (column) with the sorting order to tell it how to sort as ASCII will always put 10a before 1a.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform