>>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.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
