Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need idea for sort
Message
From
26/02/2010 07:43:49
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
26/02/2010 06:19:02
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01451160
Message ID:
01451197
Views:
37
You mean somefunc? Yes. But I would end up with 21 sort fields.

>What I call yourfuncx() could probably be inline functions.

>>>I suggest that you select into a cursor, something like this semicode
>>>Select *,;
>>>  somefunc1(yourfield) as sort1,;
>>>  somefunc2(yourfield) as sort2,;
>>>  somefunc3(yourfield) as sort3,;
>>>  somefunc4(yourfield) as sort4;
>>>  from yourtable into cursor yourcursor order by sort1,sort2,sort3,sort4
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]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform