access.logical.operators

Definition/Access: Verbs, Releases: AP and R83

Relational operators used in selection clauses.

Syntax

with {not} attr.name operator 'valuestring'

Description

a discussion of the relational and logical operators: =, eq, >, gt, <, lt, >=, ge, <=, le, #, no, not.

Logical operators are used in the selection criteria process. Each operator has an 'english' equivalent which may be used interchangeably with the 'symbol' form. When no operator is present, the default assumed is an 'equal to' (=).

= or eq equal to
# or no or not not equal to
> or gt or after greater than
< or lt or before less than
>= or ge greater than or equal to
<= or le less than or equal to

Example

sort entity with state eq 'ca'
list invoices with amount.due not '0'
list employees with birthday before '1/2/62'
list employees with age gt '21'
select entity with no zip
sort invoices with every amount > '0'

See Also

Command Name Type Description
access.ge Modifier 'greater than or equal to' operator.
access.before Modifier 'less than' operator.
access.each Modifier Forces comparison on every value.
access.le Modifier 'less than or equal to' operator.
access.modifiers Definition List of Access modifiers.
access.equal Modifier 'equal to' operator.
access.attr.name Attribute Defining Item Specifies item(s) from the dictionary of the file.
access.not Modifier Negates selection criteria.
access.after Modifier 'greater than' operator.
access.and Modifier 'and' (Boolean) operator.

User Comments

What do you think?

Share your experience or ask a question by using the form below.

Login to leave your comments.