Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting the sort order with mixed text/numbers
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00156320
Message ID:
00156394
Views:
46
Paul,

> Ok, thanks. Now I've got to look at the Web Connect docs, since everything in this cursor has to be displayed (and I definitely don't want to display my "sort" field).

Maybe do a second select that omits the sortby column, but I don't think SQL guarantees any particular order of the result unless you specify one. Is there a reason you don't PADL() the Vid field in the first place? You are going to run into the same problem in reports etc.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform