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 |
