An Old Man Needs Help

[John Esak]

Boy, I would have lost money on that one... I thought sure 4.8 did
descending indexes... sorry.


> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.com]On
> Behalf Of Bob Stockler
> Sent: Monday, March 12, 2007 10:09 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: An Old Man Needs Help
>
>
> John Esak wrote (on Mon, Mar 12, 2007 at 09:55:50PM -0400):
>
> | If the client is really on 4.8, why not just do a descending
> index on the
> | date segment??
>
> filePro 4.8.x indexes only do ascending stuff.
>
> And he didn't want to pay for 25 users on a version of filePro
> that did do descending indexes just for this.
>
> Bob
>
> | > -----Original Message-----
> | > From: filepro-list-bounces+john=valar.com at lists.celestial.com
> | > [mailto:filepro-list-bounces+john=valar.com at lists.celestial.com]On
> | > Behalf Of Bob Stockler
> | > Sent: Monday, March 12, 2007 9:33 PM
> | > To: filePro Mailing List
> | > Subject: An Old Man Needs Help
> | >
> | >
> | > I used to know how to do this, but brain fade at how many years
> | > old I am (at this age I can't remember), so I need help (though
> | > I could probably figure it out myself in a week or two).
> | >
> | > The client is on filePro 4.8.?.
> | >
> | > He needed a -decending- sort on Invoice Numbers (9,.0).  I added
> | > a field (9,.0) to the file and populated it with values that are
> | > "9999999999" - Invoice Number, which worked OK, but it turned out
> | > that his Invoice Numbers started out in 1992 to be <= 6 digits,
> | > then (at some point in time, for unknown reasons) became 7 digit
> | > numbers for a while, and then reverted to being 6 digit numbers,
> | > so he isn't getting what he wanted.
> | >
> | > So I want to give him a decending sort on dates.  I'm thinking,
> | > add a field to the records - Inverse_Date 10 mm/dd/yyyy - then
> | > populate it with "12/31/9999" - Invoice_Date, and sort on it.
> | >
> | > This is a secondary sort on Customer_Number, so I think this
> | > should do it.  Will it ? ? ?
> | >
> | > Bob (who doesn't need any "Have you tried it?" responses)
> | >
> | > --
> | > Bob Stockler +-+ bob at trebor.iglou.com +-+
> http://members.iglou.com/trebor
> | > _______________________________________________
> | > Filepro-list mailing list
> | > Filepro-list at lists.celestial.com
> | > http://mailman.celestial.com/mailman/listinfo/filepro-list
> |
> | _______________________________________________
> | Filepro-list mailing list
> | Filepro-list at lists.celestial.com
> | http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> --
> Bob Stockler +-+ bob at trebor.iglou.com +-+ http://members.iglou.com/trebor
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list