Home > MultiValue Central > Online D3 Reference > Access: Verbs > access.with

access.with

Modifier/Access: Verbs, Releases: AP and R83

Defines selection criteria in Access sentence.

Syntax

with {not} {each} attr.name {operator} {'value'}

Description

marks the beginning of a selection processor conditional, which is processed against the associated file to select items to pass on to the LIST processor.

The 'not' (or 'no') modifier negates the normal effect of selection -- only those item that do NOT meet the criteria are selected.

'value' is a specific value to match, enclosed in double quotes (') or backslashes (\). If a selection criterion does not include a value, all items that have at least one value for the specified attribute name are selected.

'every' (or 'each') specifies that in a multi-valued attribute, every value for the attribute must meet the specified condition.

'attr.name' is the name of an attribute as specified by the attribute-defining item in the dictionary.

'operator' is any legal relational operator, such as '='.

Example

list entity with contact

list entity with no contact and with phone

list invoices if amount.due > '100'

list entity if no phone.number

list entity with no contact and no phone.number

list orders if every quantity.ordered > '10'

See Also

Command Name Type Description
access.use.of.quotes Definition How quotes work in Access.
access.if Modifier
access.logical.connectives Modifier Boolean operators used in selection clauses.
access.each Modifier Forces comparison on every value.
access.seqlist Definition Definies collation sequence.
list.processor Definition Access output-processing facility.
access.sellist Definition Defines selection criteria portion of an Access sentence.
access.without Modifier Same as with no or with not.
access.modifiers Definition List of Access modifiers.
list.processor Definition Access output-processing facility.
access.attr.name Attribute Defining Item Specifies item(s) from the dictionary of the file.
access.not Modifier Negates selection criteria.
access.selection.criteria Definition Description of Access selection criteria.
access.any Modifier searches entire item for match, all attributes and values.

User Comments

What do you think?

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

Login to leave your comments.