Operator

Mandatory.  Default=Equal to

Specify the operator for the condition that will be used with the Column 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 column 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.