It is also possible to update the value of a field.
This is done using
recset with its
In the previous example, an ‘Inspected’ flag was added to certain records,
with the value ‘yes’.
After reflection, one might want to record the date of inspection, rather than
a simple yes/no flag.
Records which have no such field will remain unchanged.
$ recset -t Item -f Inspected -s '30 October 2006' stock.rec
Although the above command does not have any selection criteria, it will
only affect those records for which a ‘Inspected’ field exists.
This is because the
-s flag only sets values of existing fields.
It will not create any fields.
If instead the
-S flag is used, this will create the field
(if it does not already exist) and set its value.
$ recset -t Item -f Inspected -S '30 October 2006' stock.rec