automatic indexes, v4.5 and descending sorts
Bill Vermillion
fp at wjv.com
Thu Sep 2 09:10:54 PDT 2004
It was Thu, Sep 02 11:58 when Kenneth Brody said "Mia kusenveturilo estas
plena da angiloj. And continued:
> Jeremy Anderson wrote:
> > Is it possible to create an automatic index in v4.5 that sorts in
> > descending order?
> No. You need 5.0 for that ability.
> > I ask because it does not show up as an option for the automatic indexes
> > (though it does show up for demand indexes), for any of the files I've
> > tried. $PFOLDIX is not set.
> Demand indexes have always allowed descending.
And before the 5.0 ability I needed a descending order on dates
so I added a new field.
I took a date signifcantly far in the future to ensure that I would
always get the same number of digits up thru the 2038 date boundary
of Unix and subtracted today's date from that. I then stored that
as the key. Since the number got smaller each day an automatic
index on that new 5 digit field gave gave me a descending
field equivalent to a descending date edit.
I think I used December 12, 2099 as the date for the subtraction
target.
Bill
--
Bill Vermillion - bv @ wjv . com
More information about the Filepro-list
mailing list