The sselect command creates a sorted list of items from the specified file reference that meet selection criteria.
sselect file.reference {item.list} {selection.criteria} {sort.criteria}
{output.specification} {modifiers}{(option)}
| options | j | Suppresses all messages (n items selected, and so on). |
| s | Activates a secondary list. | |
| q | Bypasses index selection. |
The list is a temporary list that is used by the next command as its implicit item list. The list can be permanently saved by the save-list command. The list can also be passed to an Output processor command or to a FlashBASIC program if the next TCL command executes that program. When an output.specification displays in any of the various select sentences, the list is built from the contents of the specified attribute.
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 command is used with a by-exp or by-dsnd-exp modifier, the elements of the list are MultiValue, where the first value is the selected data, and the second value is the 3-digit value count. In
FlashBASIC, the two values are retrieved by the use of the readnext ID,vc form of the readnext statement.
Creates a list of invoice item-IDs that have an amount.due > 0, and which have not made a payment. The list is sorted by invoice item-ID.
sselect invoices with amount.due > 0 and with no payment
Creates a list of entity names that start with the string ROCKET sorted in name order.
sselect entity by name with name = "ROCKET]" name
.chain command (Output processor), .readnext command (Runoff), Active list, AQL command categories, compare-list command, copy command, end command (TCL commands), get-list command, nselect command, Options (Access Query Language), qselect command, readnext statement, Secondary list, nselect command, Selection criteria, Selection processor, sort-list command, wselect command