It is also possible to update the value of a field.
This is done using recset
with its -s
flag.
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