10.4.5 Defining a table (Table Designer)
This subsection explains how to define a Table object inserted using Form Designer.
Use Table Designer to define the Table object that you selected from the Object menu of Form Designer and inserted. Table Designer is displayed when you select the Table object in the edit area and click the Table Designer button displayed under the object attribute.
- Organization of this subsection
(1) Names of various components of Table Designer and how to use them
The following figure shows Table Designer.
|
|
![[Figure]](GRAPHICS/ZU121420.GIF)
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.
(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.
(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).
(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 10‒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.
|
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 |
- Legend:
-
Y: Can be set.
N: Cannot be set.
- 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.