access.sselect Verb: Access/Access: Verbs

access.sselect

Command access.sselect Verb: Access/Access: Verbs
Applicable release versions: AP, R83
Category Access: Verbs (152)
Description creates a sorted list of items from the specified file.reference that meet selection criteria.

The list is a temporary list that is used by the next verb as its implicit item.list. The list can be permanently saved by the "save-list" verb. The list can also be passed to an OP command or to a Pick/BASIC program if the next TCL command executes that program.

When an "outlist" appears in a select-class statement, the list is built from the contents of the specified attribute(s).

The elements of the list may be used as item-ids to reference data in any file, not just the file referenced in the sselect command. For example, if a "sselect" on one file is followed by a "list" on a different file, the list of item-ids generated by the sselect are used as an item.list in the "list".

In the special case where the "sselect" verb is used with a "by-exp" or "by-dsnd-exp" modifer, the elements of the list are multi-valued, where the first value is the selected data, and the second value is the three-digit value count. In Pick/BASIC, the two values are retrieved by the use of the "readnext id,vc" form of the "readnext" statement.
Syntax sselect file.reference {itemlist} {sellist} {seqlist} {outlist} {modlist}
Options j Suppresses all messages. ("n" items selected, etc.)

s Activates a "secondary" list.

w Bypasses index selection.
Example
sselect invoices with amount.due > "0" and with no payment

Creates a list of invoice item0ids which have an amount.due > o, and which 
have not made a payment. The list is sorted by invoice item-id.

sselect entity by name with name = "PICK]" name

Creates a list of entity names which start with the string "PICK" 
sorted in name order.
Purpose
Related access.seqlist
access.sellist
access.selection.criteria
secondary.list
access.select
access.options
active.list
secondary.list
access.selection.processor
tcl.wselect
tcl.sort-list
tcl.copy
tcl.qselect
basic.readnext
tcl.get-list
runoff.readnext
access.nselect
op.readnext
access.outlist
op.chain
access.modifiers.modlist
tcl.end
tcl.compare-list
access.verbs