Operator

LANSA Technical

Operator

Mandatory.  Default=Equal to

Specify the operator for the condition that will be used with the Field Name and Compare to value.

Rules

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

 

Tips & Techniques

  • 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 the Compare to value of the condition must not be a literal if this type of operation code is used.
  • The "REF" operation code is only valid for "Insert", "Update" and "Read" operations. 

Ý 2.8 Triggers