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