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