ACTIVE REVIEW (RA=)

Used to specify a SQL SELECT statement that selects which row can be reviewed with the Review Database Attributes of Element. Certain columns of the row can be selected, as can corresponding columns of other tables that are related through “join” columns.

For each table in the database, the SELECT statement is stored in the sqlreview column of the row for the table in mscatalog. When more than one table appears after the FROM clause in a SELECT statement, mscatalog is changed for only the first table.

To select which row can be reviewed

1. Key in:ACTIVE REVIEW <SQL_SELECT_statement> RA= <SQL_SELECT_statement>
   For example:
   RA=SELECT * FROM parts WHERE pc='8255' AND cost=2.10

1. In the Key-in Window, key in: RA=$
   Clicking the Next button in the SQL Window retrieves the next row.