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:
01053982
Views:
25
>>>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?
>>>
>>>TIA
>>
>>The best of the simples way is to use SYS(15), but it don't support 0h0
>>
>>INDEX ON FIELD1+sys(15,0HFFFEFD.....,field2) tag ...
>>
>
>The problem with the SYS command is the phrase "Kept for Backward compatiblity" in the help file. This makes me wonder if the command will still be around from version to version and supported. Thanks for the response.

1. This is a false problem on the last version.
2. It works. "Kept for Backward compatiblity" it doesn't have some meaning for me.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform