Philip,
There weren't descending indexes in the past. I don't quite recall when they were added but it was probably around the time that code was written. More than likely the developer wasn't used to using them and didn't want to revisit that piece of code. And, as Hilmar pointed out Rushmore may have been in the equation.
>Hi I am upgrading a system originaly written in Fox 2.2 (I think it was 2.2) for DOS. I'm converting it into Vis Fox 6. Some of the index tags in the tables use character prime key fields and do this with DATE fields.
>
>'primekeycharacterfield' + STR(999999-(AS_DATE-{01/01/1900}),6)
>
>I figure that subtracting {01/01/1900} from the date and then subtracting from 999999 will give descending values. The later the date the higher the value.
>I'm wondering why the didn't just create a descending index.
>It wouldn't make a difference whether the prime key values were in ascending or descending order, it's only the dates that matter.
>Could you not create descending indexes in Fox for dos?
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.
