-v processing

Kenneth Brody kenbrody at spamcop.net
Fri Jun 5 09:04:08 PDT 2009


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?

-- 
Kenneth Brody


More information about the Filepro-list mailing list