This section describes the Status area on the Select Tables/Views for AD panel.
The Status area on the Select Tables/Views for AD panel contains:
In the following figure, archive criteria, column specifications, selection criteria, and an SQL WHERE clause have been defined for the ORDERS table.
Figure: Multiple Status Indicators
-- Select Tables/Views for AD: GRP.FOPDEMO.AD ---------------------------------
Command ===> Scroll ===> PAGE
Primary : COL,SEL,SQL,REL,POINT,GROUP,GET TABLES RELATED,INDENT,ARC,LIST SUBS
Line : COL,SEL,SQL,ALL,GR(A),GP(A),GC(A),DR(A),PR(A),DP(A),PP(A),
DC(A),PC(A),EXP,ARC,ACT,STA
Table 1 of 4 <<MORE
Default Creator ID ===> FOPDEMO >>
Start Table ===> ORDERS >>
Start Table Options : None
R D --Extract Parms--
Cmd Status (CreatorID.)Table/View Name F A EveryNth RowLimit Type
--- ----------- ------------------------------>> - - -------- -------- -------
*** ********************************** TOP ***********************************
___ ARC/COL/... ORDERS N ____ ________ TABLE
___ CUSTOMERS N N ____ ________ TABLE
___ DETAILS N N ____ ________ TABLE
___ ITEMS N N ____ ________ TABLE
*** ******************************** BOTTOM **********************************
Status is not large enough to display all four status indicators, ARC, COL, SEL, and SQL. Use the STA line command to display the Criteria in Effect pop-up window, which lists the types of criteria in effect for the table on the Select Tables/Views for AD panel, as shown in the following figure.
Figure: Criteria in Effect
-- Select Tables/Views for AD: GRP.FOPDEMO.AD ---------------------------------
Command ===> Scroll ===> PAGE
Primary : COL,SEL,SQL,REL,POINT,GROUP,GET TABLES RELATED,INDENT,ARC,LIST SUBS
Line : COL,SEL,SQL,ALL,GR(A),GP(A),GC(A),DR(A),PR(A),DP(A),PP(A),
DC(A),PC(A),EXP,ARC,ACT,STA
Table 1 of 4 <<MORE
Default Creator ID ===> FOPDEMO >>
Start Table ===> ORDERS >>
Start Table Options : None
R D --Extract Parms--
Cmd Status (CreatorID.)Table/View Name F A EveryNth RowLimit Type
--- ----------- ------------------------------>> - - -------- -------- -------
--- ----------- ---------- - - -------- -------- -------
*** ********************** +--Criteria in Effect-+ ***************************
STA ARC/COL/... ORDERS ¦ ¦ N ____ ________ TABLE
___ CUSTOMERS ¦ Archive Criteria ¦ N ____ ________ TABLE
___ DETAILS ¦ Column Criteria ¦ N ____ ________ TABLE
___ ITEMS ¦ Selection Criteria ¦ N ____ ________ TABLE
*** ********************** ¦ SQL Criteria ¦ ***************************
+---------------------+
Before saving an Access Definition, you can provide a description to be displayed on a selection list. Use the ATTRIBUTES command to display the Object Attributes panel, which provides a 40-character area to display and edit the description. (Site management determines whether this panel also displays a prompt for Security Status.) For additional information about the Object Attributes panel, see Specify Description and Security Status.
The following commands are available when the Select Tables/Views for AD panel is displayed, except as noted.