Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a compound index with a descending portion
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01053896
Message ID:
01053916
Views:
35
This message has been marked as the solution to the initial question of the thread.
>I have an application that needs a compound index built. The fields are all string fields, but the user would like the second field to be in descending order. Is there a good way to do this in VFP?
>
Something like
INDEX ON field1 + CHRTRAN(field2, ;
	"0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz", ;
	"zyxwvutsrqponmlkjihgfedcba`_^]\[ZYXWVUTSRQPONMLKJIHGFEDCBA@?>=<;:9876543210") TAG t1
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform