access.sselect
Creates sorted list of items meeting specific criteria.
Syntax
sselect file.reference {itemlist} {sellist} {seqlist} {outlist} {modlist}
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.
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.
See Also
User Comments
What do you think?
Share your experience or ask a question by using the form below.
Login to leave your comments.