RDOHELP72.HLB  —  DEFINE_TRIGGER, Format  field-name
    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.
Close Help