-v processing

Richard Kreiss rkreiss at gccconsulting.net
Fri Jun 5 10:14:26 PDT 2009



> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> Sent: Friday, June 05, 2009 12:04 PM
> To: rkreiss at gccconsulting.net
> Cc: filepro-list at lists.celestial.com
> Subject: Re: -v processing
> 
> Richard Kreiss wrote:
> > Quick question,
> >
> > I have a -v process which check another file to verify data in the
record
> > selected before it is processed for the report.  One of the fields is
used
> > in the sort.
> >
> > The lookup puts the actual value in this field if it is missing or
> > different.  However the value is blank.
> >
> > May I assume that -v process, like auto processing, can't write to a
record?
> 
> If, by "a record", you mean "the current record in the main file", then
you
> are correct.  The records are not locked during the sort/select phase.
> 
> > My solution would be to set a dummy variable to hold this value for
sorting
> > and then do a lookup in processing to write the value to the current
record.
> 
> You could use the SORTn command to set the value to sort, but you can't
> change the value of a field in the main record because, as I said above,
you
> are not in update mode during the sort/select phase.
> 
> Could you do the same lookup during the output phase to change the actual
> field contents?

I can update from the output process.

As I indicated, I need a temporary variable to hold this value for use with
sortn.

Richard


> 
> --
> Kenneth Brody



More information about the Filepro-list mailing list