The name of a field within the specified relation to be checked for modification. You can specify a list of field names separated by commas. You can also specify all the fields in a relation by specifying the asterisk (*) wildcard character. Be sure that you specify ONLY those fields whose data values are to be changed. See the subtopic More for more information.
1 – More
In a BEFORE MODIFY or AFTER MODIFY trigger, be sure that you specify only the names of fields whose data values are to be changed, to avoid potentially unnecessary actions such as: o Overlaying the data with itself within a record. o Writing to the database (even though none of the fields in the record has actually changed values) o Evaluating constraints that apply to fields in the MODIFY field list which have not changed values o Evaluating MODIFY triggers that apply to fields in the MODIFY field list that have not changed values. o Evaluating RDO VALID IF clauses for fields in the MODIFY field list that have not changed values. If there is a possibility that any of the fields in a MODIFY field list will not actually be changed, the triggered actions for any pertinent MODIFY triggers should be changed accordingly. For those cases in which a triggered action performs an operation based on the changed value for a particular field, the action should include a conditional expression that prevents execution of the operation if no value change occurs. The conditional expression, which compares the old value with the new value, should appear as part of the triggered action's WITH clause.