another -v processing question

[John Esak]

I hate to keep doing this... But just to keep the record straight it was Me
who came upon the idea of lookup - on a -v table... Not Nancy.  I told her
how to do it on the phone one day... The article which may be later I don't
remember in The Guru was "It's Called Lookup Dash".

In case it matters to anyone or anyone thinks there is some kind of rivalry
between Nancy and I... Not so. I have learned as much and more from her than
she has from me I'm sure.

John
 

> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com 
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
m] On Behalf Of Boaz Bezborodko
> Sent: Friday, June 05, 2009 2:46 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: another -v processing question
> 
> >
> > Message: 8
> > Date: Fri, 5 Jun 2009 14:12:41 -0400
> > From: "Dennis Malen" <dmalen at malen.com>
> > Subject: another -v processing question
> > To: <filepro-list at lists.celestial.com>
> > Message-ID: <026a01c9e609$37abcd30$0cb21309 at dennisoffice>
> > Content-Type: text/plain; format=flowed; charset="iso-8859-1";
> > 	reply-type=original
> >
> > Will future versions of filepro every allow -v to take 
> advantage of an 
> > automatic index. Once a file has a substantial amount of 
> records, the time 
> > complete process gets longer and longer.
> >
> > OR is there any way around it?
> >
> > Dennis Malen
> > 516.479.5912 
> >   
> There is a way to do it now.
> 
> When you execute RREPORT with the -i[n] (where [n] is the letter 
> denoting the index) you can move within the file using a LOOKUP -.
> 
> What I do is a build an index that allows me to move to the 
> beginning of 
> the records I want to select and then, once I'm past them, I 
> lookup to a 
> record past the end of the file to end quickly.
> 
> ::INPUT aa(8,mdy/) "Enter starting date: "
> ::INPUT ab(8,mdy/) "Enter ending date: "
> ::LOOKUP - k=ba  i=A -ng
> 
> Skip this lookup after the first record.
> 
> After the selection line do a check to see if the records are 
> now past 
> the ending date.
> : 1 gt ab
> :: LOOKUP - k="12/31/2200" i=A -ng
> 
> I believe it was Nancy Palmquist who wrote about this quite 
> some time ago.
> 
> 
> Boaz
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>