-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