sorting a lookup

[Scott Walker]

Create the new index and use in processing to do the browse lookup.

Should be a (10) minute fix.

Regards,

Scott


> -----Original Message-----
> From: filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf Of
> scooter6 at gmail.com
> Sent: Wednesday, June 27, 2012 12:54 PM
> To: filepro-list at lists.celestial.com
> Subject: sorting a lookup
> 
> CentOS Linus and fp 5.6.10R4
> I have in my input processing for my operations staff a lookup that looks
> at previous letters that have been sent...
> 
> The crux of it should lookup to file A using account number in a browse
> lookup to show previous letters sent It does this using index A in file A
> which is account number....now I need to find the 'most recent' record in
> the browse lookup For now, it will show
> 
>   Date                Letter                 Date Req
> 09/11/11          Letter 1              09/10/11
> 10/15/11          Letter 2              10/14/11
> 06/23/12          Letter 3               06/22/12
> 
> 
> The way my processing 'should' work is it should find the 'MOST RECENT'
> letter (in this case, the one from 06/23/12) and it should capture the
> date
> 06/23/12 and compares it to today....if it hasn't been 14 days or more, it
> pops up a message saying 'hasn't been 14 days...' blah blah blah This was
> written a LONG time ago...apparently, this method only works if there is
> ONE record it finds in the above browse and that date is within the last
> 14 days How do I get it to first, find all the records in file A using
> account number and THEN have it sort by date?  Should I just create a
> separate index that is acct num & date combined? (Assume that's the easy
> fix here
> right?)
> Or is there a better/faster way to do this within the code that will
> 'loop'
> thru the records and grab the 'most recent' one
> 
> Hope that makes sense
> thanks
> 
> Scott
> PDM
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20120627/f474e5bc/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list