Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting strings with integers..
Message
From
11/01/2007 23:58:32
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
11/01/2007 19:51:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6
Miscellaneous
Thread ID:
01184851
Message ID:
01184893
Views:
16
>Do I have to modify all records? I have so far 1000 records already of that format :(

You better do that now, while you have only 1000.

use yourtable
set order to 0
replace yourkey with left(yourkey,2)+transform(val(subs(yourkey,3)), "@L 999") all

And make sure new keys added are made this way. You can actually do this same thing in the lostfocus of the textbox (if any user is entering these), or simply change the logic of your function that creates them to make them this way.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform