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

access.by

Modifier/Access: Verbs, Releases: AP and R83

Defines (ascending) sort key in Access sentence.

Syntax

by attr.name {by attr.name ...}

Description

designates a sort key, in ascending order. It must be is followed by an 'attr.name'.

In Advanced Pick, 'by' may be used with any verb that lists or selects items, such as 'list' or 'select'. R83 did not allow 'by' to be used with 'non-sorting' verbs, and was simply ignored.

Example

sort entity by zip

sselect invoices by date by customer

sort entity with name = '[mike]' by name

See Also

Command Name Type Description
access.sort Verb: Access Sorts file.
access.by-exp Modifier Explodes multi-values for sorting purposes.
access.by-dsnd Modifier Defines descending sort key in Access sentence.
access.modifiers Definition List of Access modifiers.
access.by-exp-dsnd Modifier Explodes multi-values in descending sequence.
access.break-on Modifier Creates control break in Access reports.
access.attr.name Attribute Defining Item Specifies item(s) from the dictionary of the file.
access.seqlist Definition Definies collation sequence.
b-tree Definition Balanced-tree index.
collation.order Definition Definition of collation order.

User Comments

What do you think?

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

Login to leave your comments.