View Source

[ |../../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 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.

[ |../../index.htm#lansa/l4wtgu02_0245.htm]