As mentioned above, the command
recins adds new records to a
recfile, but it cannot
add fields to an existing record.
This task can be achieved automatically using
recset with its
Suppose that (after a stock inspection) you wanted to add an ‘Inspected’ field to all the items in the recfile. The following command could be used.
$ recset -t Item -f Inspected -a 'Yes' stock.rec
Here, because no record selection flag was provided, the command affected all the
records of type ‘Item’.
We could limit the effect of the command using the
For example to add the ‘Inspected’ field to only the first item the following command
$ recset -t Item -n 0 -f Inspected -a 'Yes' stock.rec
Similarly, a selection expression could have been used with the
-e flag in order to
add the field only to records which satisfy the expression.
If you use
recset with the
-a flag on a field that already exists, a
new field (in addition to those already present) will be appended with the given value.