access.sellist

Definition/Access: Verbs, Releases: AP and R83

Defines selection criteria portion of an Access sentence.

Description

represents the set of selection criteria clauses that determine which items should be selected for processing by Access.

See the 'with' modifier for additional information on selection criteria clauses.

Example

list entity with name 'ar]' name

In this example, only those items whose 'name' field begins with
'ar' are selected. (See 'selection criteria' for more
information).

list entity with name 'mi]' and with phone '804]'

This example shows two selection clauses connected with an 'and',
which means that both conditions must be evaluated as true for items to be
selected for processing.

list entity with name 're]' or with city 'irv]' name city

This example shows a mutually exclusive set of selection crtieria connected
with an 'or'. Either condition evaluating to true accepts the item
for processing, that is, if the 'name' attribute begins with
'ar', or the 'city' attribute begins with 'irv',
the item is selected for output.

list entity with name 'ar]' and with city 'irv]' or with
city 'san]' and with contact '[joe]'

This example lists those items which meet one of two criteria: a name starting
with 'ar' and with a city starting with 'irv', or, a city
starting with 'san' and a contact containing the string
'joe'.

See Also

Command Name Type Description
access.select Verb: Access Creates list of items meeting specific criteria.
access.without Modifier Same as with no or with not.
access.t-dump Verb: Access Dumps items to tape.
access.selection.processor Definition Gathers items for Access processes.
access.sselect Verb: Access Creates sorted list of items meeting specific criteria.
tcl.sortc Verb: Access Sorts item-ids in four-column format. Invokes program 'listc'.
access.sreformat Verb: Access Reformats data in sorted order to file or tape.
access.sort Verb: Access Sorts file.
access.t-load Verb: Access Loads data from t-dump format magnetic media.
access.with Modifier Defines selection criteria in Access sentence.
access.s-dump Verb: Access Dumps items to tape in sorted order.
access.sum Verb: Access Displays total of numeric field.
access.nselect Verb: Access Performs 'not' select - only items not there.
wildcards Definition allows Access to search for strings beginning with, ending with, or containing a given string.
access.sort-label Verb: Access Produces formatted and sorted labels.
access.stat Verb: Access Displays total and average of numeric field.
tcl.ld Verb: Access Displays sorted file dictionary.
access.list-label Verb: Access Produces formatted labels.
access.count Verb: Access Counts items in a file.
access.list-item Verb: Access Displays item in storage format.

User Comments

What do you think?

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

Login to leave your comments.