D3Codex
ACCESS / AQL

sort command

.md

The sort command generates sorted and formatted output of selected items and attributes from a specified file. The output produced by sort is identical to the output produced by list when the by modifier is specified. The default sort sequence can be altered by using the ms processing code (see ms (Mask Alter Sort) processing code for more information.

Syntax

sort file.reference {item.list} {selection.criteria} {sort.criteria}
{modifiers} {output.specification} {print.limiters} {(options)}

Example(s)

Prints a list of entity items sorted by company and name, whose name starts with ROCKET. The company and name are printed, and the entity item-ID is not printed.

sort entity by company by name with name "ROCKET]" company name id-supp (p

See also

by modifier→by-dsnd modifier→by-exp modifier→by-exp-dsnd modifier→AQL command categories→Item list→list command→Modifiers→ms (mask alter sort) processing code→Options (Access Query Language)→Selection criteria→set-compat command→wsort command→

Referenced by

11 topics mention sort command in its description.

break-on modifierfmt modifierPhrasessort-item commandss modifierFlashBASIC features that function differently in D3 Windows vs. UNIXlist-file-stats commandlist-system-errors macropaint commandPointer itemupdate command