>>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
>
Do you think it's the best approach?
After re-reading the whole thread I see, that there is another better suggestion.
If it's not broken, fix it until it is.
My Blog