Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complex index is this possible?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01575993
Message ID:
01575996
Views:
54
>I want to index a file on descending order of fields 1 and 2 but within that on ascending oder of fields 3 - how can I do this?
>
>I have tried this but it doesn't work
>
>index on dupkey+codex DESCENDING, COPYNO ASCENDING TAG docky

You could use SQL SELECT and ORDER BY instead.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform