5.2 Setting Fields

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