The Change Row command puts the dialog in change row mode, which overrides the key-in mode for key column, add query, and update active fields. Key column, add query, and
update active fields can be placed on custom dialogs created with RIS Report Writer.
By default, the multiple column field on the Database Edit dialog is in change row mode. To update a value in the current row, select the appropriate column field and key in a new value. The row is automatically updated in the database.
You cannot use Change Row to edit a serial column (INFORMIX). You cannot enter duplicate values in a column used for unique row identification (mslink, mscatalog.key column, or unique index). For more information, see sections Editing Database Values and RIS Report Writer Reserved Tables.
Operating Sequence
1. Select Change Row.
The Change Row button appears to be depressed. The screen dialog is in change row mode; any column values you edit are updated in the database.
2. Select a key column, add query, or update active field. Key in a new value. The messageRow changedappears.
3. Continue to select column fields and key in new values until all changes have been made.
__________________________________________________________________________________________________________________________________________________
Column (Report Builder)
The Column (Report Builder) command places a field that retrieves and prints column values from the current universe of rows. Column fields are the most important on the report template, because they retrieve information fields from the database, user data file, or ASCII file. Column fields are usually placed on body lines.
Join columns let you use a single table report to report on more than one table. Any two database tables that have columns with common values can be joined. See the section Join Columns.
There is no need to use the more complex unrelated table report unless the tables are not related. For example, to report on the manufacturer and sale tables, which do not share a join column, you need an unrelated tables report template. You must place separate body lines for each table in the report.
Dialog Options
RIS Report Writer Commands C - 5
The following list describes the options on the menu except for the Print Condition field, which is described in the section Place Field.
Schema — This field specifies the schema containing the table for which you want to
place a column field. You can key in a new schema name or use the list indicator to select a new schema.
Table — This field specifies the table for which you want to place a column field. You
can key in a new table name or use the list indicator to select a new table.
Column — This field specifies the column from the current table for which you want to
place a column field. You can key in a new column name or use the list indicator to select a new column.
Join Columns — This button lets you review and edit the join column relationship.
The button is inactive until join columns are specified.
If you place a column field from a table other than the current table on a single table report, you must specify a join column between the primary (that is, the current) table and the secondary table. See the section Join Columns.
Code Text/Number — These radio buttons lets you specify whether the column field
displays the code number or code text for a coded column. These radio buttons are inactive until a coded column is specified in the Column field.
Length — This field specifies the character length of the column field.
Decimal Places — This field specifies the number of decimal places for numeric data.
Operating Sequence
1. Select Column from the Report Builder menu bar. The DBA Column Field dialog appears.
2. At the Column field, enter the name of a column from the current table using key-in or the list indicator. Go to Step 5.
— OR —
At the Schema and/or Table field, enter a new schema and/or table using key-in or the list indicator.
The DBA Join Columns dialog appears.
3. At the Column field for the primary table, enter the name of the join column using key-in or the list indicator. Repeat for the secondary table.
— Then —
Specify whether the join is an outer join. Select OK to return to the DBA Column
Field dialog.
The DBA Join Columns dialog disappears. The Join Columns button on the DBA
Column Field dialog is active.
You can optionally specify all table relations in your database through Edit Relations (Utilities - Schema Edit.)
4. At the Column field on the DBA Column Field dialog, use key-in or the list indicator to enter the name of the column from the secondary table for which you want to place a field.
5. Set any other parameters as needed. Select OK.
The field is dynamically attached to the cursor. The values in the message area can help you position the field on the dialog. RIS Report Writer uses F-1, F-2, and so on to represent the first, second, and any subsequent fields on a line.
6. Click the left mouse button to place the field.
The field is inserted before the current field (if any), with one space separating the two fields. Any fields to the right of the new field will shift to the right.
You can realign the fields using the following commands:
Move Field Delete Field
Undelete Field (Report Builder)
Insert Space (Report Builder) Delete Space
— OR — Select Cancel to end the placement.
RIS Report Writer Commands C - 7
Once you establish a join column between two tables, you can place additional column fields from the secondary table. The DBA Join Columns dialog does not reappear.
__________________________________________________________________________________________________________________________________________________