sselect

Syntax	sselect file.reference {itemlist} {sellist} {seqlist} {outlist} {modlist}
Category	Access
Type	Verb
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 FlashBASIC 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 FlashBASIC, the two values are retrieved by the use of the "readnext id,vc" form of the "readnext" statement.
Options	j Suppresses all messages. ("n" items selected, etc.) s Activates a "secondary" list. w Bypasses index selection.
See Also	seqlist sellist selection criteria secondary list select options: active list secondary list selection processor wselect sort-list copy qselect READNEXT get-list readnext nselect readnext outlist chain modlist end compare-list Access verbs
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.
Warnings
Compatibility	D3 7.0 AP R83

Index Level

stat