Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Operations allowed are:

    GT 

    Greater than

    GE 

    Greater than or equal to

    LT 

    Less than

    LE 

    Less than or equal to

    EQ 

    Equal to

    NE 

    Not equal to

    REF

    Refers to

     
  • All operation codes can be suffixed by a "P" indicating that the previous value of the nominated field should be used. Such conditions are only valid for "Update" operations. Also Part 2 of the condition must not be a literal if this type of operation code is used.
  • No conditions are allowed if "Open" or "Close" are used.
  • The "REF" operation code is only valid for "Insert", "Update" and "Read" operations.
  • If the trigger is defined at dictionary level, the conditions can only involve the field to which the trigger is being linked.
  • If the trigger is defined at the file level, the conditions can involve any other real or virtual fields in the file to which the trigger is being linked.

...