12.4.5 Defining a table (Table Designer)

(1) Names of various components of Table Designer and how to use them

The following figure shows Table Designer.

Figure 12‒25: Table Designer

In Table Designer, you set the attribute of the items that constitute a table.

• Table Operations

  Displays the Table Operations menu. You can add or delete rows and columns.

• Row Attributes

  Sets a style for the selected row.

• Column Attributes

  Sets an object attribute for the selected column.

Click the OK button to save the Table object being edited and close Table Designer. Click the Cancel button to discard the Table object being edited and close Table Designer.

To Page Top

(2) Defining rows and columns for the table (Table Operations)

Click Table Operations to display a menu. Click the desired menu command and define rows and columns for the table. The following menu commands are displayed:

• Add row

  Adds a single row. The maximum number of rows that can be defined is 10.

• Delete row

  Deletes a single row. You cannot delete a row if the table has only a single row.

• Add column

  Adds a column to the last column. The maximum number of columns that can be defined is 10.

• Delete column

  Deletes the selected column. You can delete only a single column. You cannot delete a column if the table has only a single column.

To Page Top

(3) Setting the row style (Row Attributes)

Click Row Attributes to define a row style. Selecting a row or column displays Row Attributes. The following styles can be defined:

• Background color

  Sets a background color for the selected row. Select a color from the color palette that is displayed when you click the set color area. To set gradation, click a gradation pattern.

• Font

  Sets a font for the selected row. Select a font from the font list that is displayed when you click the set font area.

• Font size

  Sets a font size for the selected row. Select a font size from the font size list that is displayed when you click the set font size area.

• Character color

  Sets a character color for the selected row. Select a color from the color palette that is displayed when you click the set color area.

• Font decoration

  Sets font decoration for the selected row. Choose B (bold), I (italic), or U (underline).

To Page Top

(4) Setting the column object attributes (Column Attributes)

Click Column Attributes to define an object attribute for each column. Selecting a row or column displays Column Attributes. The following object attributes can be defined:

• Item name

  Sets an item name for the selected column. Specify a double-byte or single-byte character string between 1 and 32 bytes. The default is Item.

• Data type

  Sets a column data type. Select the desired data type from the drop-down list. The data types that can be set are listed below. The default is Any double-byte character string.

  • Any double-byte character string

  • Any single-byte character string

  • Alphabetic

  • Alphanumeric

  • Group reference

  • Location reference

  • User reference

  • Numeric

  • Date (YYYYMMDD)

  • Date (YYYYMM)

  • Date (MMDD)

  • Time (HHMMSS)

  • Time (HHMM)

• Maximum length

  Sets the maximum length for the data that can be input to a column item. The maximum value that can be set is 1,024 bytes. The default is 1,024 bytes.

• Initial value

  Sets the initial value for a column item. The initial value that can be set varies depending on the data type. The following table shows the initial value that can be set by data type.

  Table 12‒3: Initial values that can be set

  Data type	Initial value that can be set
  Group reference	Group of applied user
  User reference	Applied user name
  Date	Applied date
  Time	Applied time
  Other data type	Any

• Reference range

  Sets the range of column items that can be referenced. Select either Reference the range of filtering or Reference all. The default is Reference the range of filtering.

  This item is displayed when one of the following data types is set:

  • Group reference

  • User reference

• Maximum and Minimum

  Sets the maximum and minimum numeric values that can be specified for column items. The value range permitted for Maximum and Minimum is -2,147,483,648 to 2,147,483,647. The default for Maximum is 2,147,483,648. The default for Minimum is -2,147,483,647.

  This item is displayed when Numeric is set for the data type.

• Read-only

  When this check box is selected, the set columns are displayed as read-only when the Item window is displayed.

• Non-display

  When this check box is selected, the set columns are not displayed when the Item window is displayed.

Note that some object attributes cannot be set (displayed) depending on the data type. The following table shows the correspondence between data types and object attributes.

Table 12‒4: Correspondence between data types and object attributes

Data type	Object attribute
	Maximum length	Initial value	Reference range	Maximum	Minimum
Any double-byte character string	Y	Y	N	N	N
Any single-byte character string	Y	Y	N	N	N
Alphabetic	Y	Y	N	N	N
Alphanumeric	Y	Y	N	N	N
Group reference	N	Y	Y	N	N
Location reference	N	N	N	N	N
User reference	N	Y	Y	N	N
Numeric	N	Y	N	Y	Y
Date (YYYYMMDD)	N	Y	N	N	N
Date (YYYYMM)	N	Y	N	N	N
Date (MMDD)	N	Y	N	N	N
Time (HHMMSS)	N	Y	N	N	N
Time (HHMM)	N	Y	N	N	N

Note

When the number of rows or columns to be displayed is changed through a table operation or column display or non-display, the size of the entire table is changed based on the current row and column sizes.

To Page Top