The Boolean Assignment command supports operations such as A=B>C and A=B<C. This allows you to run logic over a series of commands instead of a series of If Then statements. The variable in the Destination parameter must be a Boolean datatype.
Select Boolean Assignment from the Rule Command - New window. In the Parameters section, select the variables for each of the parameters of the Boolean Assignment command by clicking the up arrow to the right of each Parameter text box and selecting one of the options in the menu that displays.
Left – options are:
Memory Variable – the Memory Variables window displays next to the Rule Command window. Double-click or drag and drop a memory variable to enter it in the Left text box.
Record/Field – the Records/Tables window displays next to the Rule Command window. Double-click or drag and drop a field to enter it in the Left text box.
System Variable – the System Variables window displays next to the Rule Command window. Double-click a system variable to automatically enter it in the Left text box.
Operator – options are:
EQ – enters the Equal To operator in the Operator text box.
NE – enters the Not Equal To operator in the Operator text box.
GT – enters the Greater Than operator in the Operator text box.
GE – enters the Greater Than or Equal To operator in the Operator text box.
LT – enters the Less Than operator in the Operator text box.
LE – enters the Less Than or Equal To operator in the Operator text box.
Right – options are:
Memory Variable – the Memory Variables window displays next to the Rule Command window. Double-click a memory variable to automatically enter it in the Right text box.
Record/Field – the Records/Tables window displays next to the Rule Command window. Double-click a field to automatically enter it in the Right text box.
System Variable – the System Variables window displays next to the Rule Command window. Double-click a system variable to automatically enter it in the Right text box.
Constant – enter a value in the text box on the Constant Value window that displays and select OK. The value is entered in the Right text box.
Destination – options are:
Memory Variable – the Memory Variables window displays next to the Rule Command window. Double-click or drag and drop a memory variable to enter it in the Destination text box.
Record/Field – the Records/Tables window displays next to the Rule Command window. Double-click or drag and drop a field to automatically enter it in the Destination text box.
Table 2-3 lists the possible expressions you can use with the Boolean Assignment command and the corresponding datatypes you can use for the Left and Right operands and the Destination.
Expression |
Left operand |
Right operand |
Destination |
|---|---|---|---|
B>C, B<C, B>=C,B<=C, B==C, B!=C |
Alphanumeric |
Alphanumeric |
Boolean |
B>C, B<C, B>=C,B<=C, B==C, B!=C |
Date |
Date |
Boolean |
B>C, B<C, B>=C,B<=C, B==C, B!=C |
Time |
Time |
Boolean |
B>C, B<C, B>=C,B<=C, B==C, B!=C |
Decimal Explicit, Decimal Implicit, Packed Decimal, Real, Signed Decimal, Signed Integer, and Unsigned Integer |
Decimal Explicit, Decimal Implicit, Packed Decimal, Real, Signed Decimal, Signed Integer, and Unsigned Integer |
Boolean |
B==C |
Boolean |
Boolean |
Boolean |
B!=C |
Boolean |
Boolean |
Boolean |
