another -v processing question

Boaz Bezborodko boaz at mirrotek.com
Fri Jun 5 11:45:59 PDT 2009


>
> 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


More information about the Filepro-list mailing list