Chapter 3: Building Production Objects

Table Maintenance window fields

The Table Maintenance Window contains these fields and options, in addition to the display pane in the center of the window, where the actual table data displays.

Field (key)	Description
Table Name	Enter the name of the table. The name can be a maximum of eight characters and contain only letters, numbers, and the underscore (_) character. TRAN-IDE uses this name to reference the table in a rule object.
Description	Enter an optional description of the table’s contents.
Row	This field is only for reference and displays the row where the cursor is currently located. Row numbering starts at zero (0).
Column	This field is only for reference and displays the column where the cursor is currently located. Column numbering starts at zero (0).
Page	The page number you are viewing. There are 50 rows to a page. To view a different page, enter the page number in the field or click the up and down arrows until you reach the desired page number, then press Enter.
Width	The width of the currently selected column, between 1 and 40 characters. Enter a value in this field and press Enter or click Update to change all columns to that width.
Cell Value	The data to enter in the selected cell. Also displays the contents of the currently selected cell.
Search	Allows you to search for a row in the table. You only the currently selected column. Select the column in which you want to search for data, then enter the value for which to search in this field and press Enter or click Go. If the value is present, TRAN-IDE highlights the value in display pane and displays the row’s data in Cell Value field. If the value is not present, TRAN-IDE displays a message that prompts you to select Add Row to add the row to the table. Search is case sensitive, so a search for “jane doe” will not match on the value “Jane Doe”.
Default Row	Select this option to mark the currently selected row as the table’s default row. A default row has an asterisk (*) following its values in the display pane.
Add Row button	Adds a row to the end of the table. The cursor rests on the far left column of the new row. Enter the value to enter in this cell in the Cell Value field and press Enter. TRAN-IDE places empty strings ("") or zeros (depending on a column’s datatype) into the other columns. Use the Cell Value field to edit the other columns in the new row.
Input Modes	Specifies how the cursor responds when you add the data that entered in the Cell Value field. Cell – after entering the data in the Cell Value field, the cursor remains on that cell. Row – after entering the data in the Cell Value field, the cursor moves to the next row down. If the data was entered in the last row, the cursor remains there. Column – after entering the data in the Cell Value field, the cursor moves to the next column to the right. If the data was entered in the last column, the cursor remains there. Add Row – when you have Row or Column chosen and select this option, you can add rows to the end of the table by simply pressing Enter. The data entered in the new row replicates the data that the cursor highlighted when you pressed Enter or the data in the Search field.

The Table Maintenance window also has these buttons:

Button	Description
Add Row	Adds a row to the end of the table using the value in the Search field for the selected column cell. Empty strings ("") or zeros (depending on a column’s datatype) into the other columns. Use the Cell Value field to edit the other columns in the new row.
Remove Row	Removes the entire row of the currently cell.
Add Column	Opens the Add Column window, which allows you to add a column after the table’s last column on the right.
Edit Column	Opens the Column Information window. You can change the column name and whether the column is a key column. You cannot change the datatype.
Update	Adjusts every column to the value specified in the width field, or changes the selected cell’s data to the data that you enter in the Cell Value field.
Import	Opens the Table Import window, which allows you to import a file from which to build a table. See “Importing table objects” for instructions.
Save	Saves a new table with the name you enter or saves an existing table with the same name.
Save As	Saves a new table with the name you enter pr saves an existing table with a different name.
Close	Closes the window after asking if you want to save any changes.

View this book as PDF