WITH is a selection modifier that introduces a selection expression.
Format
|
WITH [{EVERY | EACH}] attribute-name [[rel-op] value-list] [{AND | OR} attribute-name [[rel-op] value-list]...] |
Parameter(s)
|
{EVERY | EACH} |
Specifies that all values in a MultiValued attribute must meet the specified condition if the item is to be included in the report. |
|
attribute-name |
Name of the attribute whose data values are to be compared to the specified condition. |
|
rel-op |
Can be any relational operator. |
|
value-list |
Can be either one or more data values, or a constant. Values should be enclosed in double quotes. |
|
{AND | OR} |
Specifies a compound expression. AND requires that all conditions be met before an item is selected; OR requires that only one of the conditions be met. |
Description
Multiple WITH expressions can be used in an INFO/ACCESS query and are normally read left to right. If a WITH expression is enclosed in parentheses, it takes precedence over any other WITH expressions in the query.
Synonym
|
IF |
Examples
This example lists all customers named Robert Smith:
|
>LIST CUSTOMERS WITH LAST-NAME "SMITH" AND WITH FIRST-NAME "ROBERT" |
This example lists all orders with either a part description of SERIAL CABLE or CABLE - SERIAL:
|
>LIST ORDERS WITH DESC. = "SERIAL CABLE" OR WITH DESC. = "CABLE - SERIAL" |
See Also