Page History
[ 
|../../index.htm#lansa/l4wtgu02_0245.htm]
You are here:
...
Operator
Mandatory. Default=Equal to
Specify the operator for the condition that will be used with the Column Name and 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 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.
...