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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement