Select Rows
Select rows from the Start Table using the SR line command or the SELECT RELATED primary command. For example, in the following figure, a single row is selected by specifying the SR line command, and a block of rows is selected by specifying two SSR line commands; the first SSR line command identifies the first row in the block of rows, and the second SSR identifies the last row in the block.
--------------------------- Optim: Point-and-Shoot ---------- 18 ROWS SELECTED
Command ===> Scroll ===> PAGE
Cmd F == Table: FOPDEMO.ORDERS(T1) ======================= 1 OF 1000 === MORE>>
ORDER_ID CUST_ID ORDER_DATE ORDER_TIME FREIGHT_CHARGES ORDER_SALESMAN
-------- ------- ---------- ---------- --------------- --------------
*** *********************************** TOP ***********************************
_ S 7 00721 2005-04-26 14.22.31 9.22 NE005
SR_ 8 00021 2005-04-26 14.22.31 9.22 SC005
9 02123 2005-04-26 14.22.31 9.22 SW005
SSR 10 00049 2005-04-26 14.22.31 9.22 WE005
___ 11 00026 2005-04-26 14.22.31 9.22 SE005
___ 12 00393 2005-04-26 14.22.31 9.22 NE005
___ 13 03214 2005-04-26 14.22.31 9.22 NW005
___ 14 00309 2005-04-26 14.22.31 9.22 SC005
___ 15 00352 2005-04-26 14.22.31 9.22 SC005
___ 16 00264 2005-04-26 14.22.31 9.22 NW005
___ 17 00168 2005-04-26 14.22.31 9.22 SW005
___ 18 01021 2005-04-26 14.22.31 9.22 SE005
___ 19 00454 2005-04-26 14.22.31 9.22 NC005
20 00001 2005-04-26 08.16.09 14.80 NE005
SSR 21 05075 2005-04-26 08.16.09 14.80 SC005
___ 22 00077 2005-04-26 08.16.09 14.80 SW005
___ 23 00068 2005-04-26 08.16.09 14.80 WE005
As an example of the SELECT RELATED primary command, enter the following to select all orders for salesman SC005:
SELECT RELATED IN ORDER_SALESMAN ALL SC005
Reverse a selection by using the UR line command or the UNSELECT RELATED primary command. In the following figure, the last selected row, Order 21, is unselected.
--------------------------- Optim: Point-and-Shoot ---------- 25 ROWS SELECTED
Command ===> Scroll ===> PAGE
Cmd F == Table: FOPDEMO.ORDERS(T1) ======================= 1 OF 1000 === MORE>>
ORDER_ID CUST_ID ORDER_DATE ORDER_TIME FREIGHT_CHARGES ORDER_SALESMAN
-------- ------- ---------- ---------- --------------- --------------
*** *********************************** TOP ***********************************
___ S 7 00721 2005-04-26 14.22.31 9.22 NE005
___ S 8 00021 2005-04-26 14.22.31 9.22 SC005
___ 9 02123 2005-04-26 14.22.31 9.22 SW005
___ S 10 00049 2005-04-26 14.22.31 9.22 WE005
___ S 11 00026 2005-04-26 14.22.31 9.22 SE005
___ S 12 00393 2005-04-26 14.22.31 9.22 NE005
___ S 13 03214 2005-04-26 14.22.31 9.22 NW005
___ S 14 00309 2005-04-26 14.22.31 9.22 SC005
___ S 15 00352 2005-04-26 14.22.31 9.22 SC005
___ S 16 00264 2005-04-26 14.22.31 9.22 NW005
___ S 17 00168 2005-04-26 14.22.31 9.22 SW005
___ S 18 01021 2005-04-26 14.22.31 9.22 SE005
___ S 19 00454 2005-04-26 14.22.31 9.22 NC005
S 20 00001 2005-04-26 08.16.09 14.80 NE005
UR_ S 21 05075 2005-04-26 08.16.09 14.80 SC005
___ 22 00077 2005-04-26 08.16.09 14.80 SW005
___ 23 00068 2005-04-26 08.16.09 14.80 WE005
Only Start Table rows are selected or unselected directly. However, rows from other tables in the Access Definition are also selected if related to a selected Start Table row and, in a joined display, show the “S” status flag.