Safeguard Audit Service Manual (G06.24+, H06.03+)

Producing SAFEART Reports
Safeguard Audit Service Manual—520480-014
6-6
SET Command
relational-operator
is one of these:
If the record item is an enumerated field, only = and <> are valid operators.
value
specifies what record-item is compared to. It must be the same type as
record-item. For example, if the item is a numeric field, value must be
a number. For more information, see Section 7, SAFEART Field
Descriptions.
logical-operator
The logical-operators are:
Considerations
•
Except for the SET WHERE command, the reporting criteria specified by each SET
command replace any reporting criteria previously defined with that command
during the current SAFEART session.
•
Reporting criteria specified in a SET WHERE command are added to any criteria
previously specified in a SET WHERE command. Therefore, issue a RESET
WHERE command before a SET WHERE command to clear any previously
defined reporting criteria.
= equal to
<> not equal to
< less than
<= less than or equal to
> greater than
>= greater than or equal to
LE less than or equal to
NE not equal to
GE greater than or equal to
AND Connects two or more compare-statements. All
compare-statements connected by AND must be true for an
event to be selected.
OR Connects two or more compare-statements. At least one of the
compare-statements connected by OR must be true for an event
to be selected.
NOT Modifies a compare-statement. The compare-statement
following NOT must be false for the event to be selected.