Try OpenEdge Now
skip to main content
Basic Database Tools
Advanced Menus Reference : Utilities menu : Generate Include Files option : FORM Statement option
 
FORM Statement option
Choose Generate Include Files > FORM Statement to generate a FORM statement for a table. The Data Dictionary alphabetically lists all the tables defined for your database. When you select a table, the Generate FORM for "selected-table-name" dialog box appears, as shown in the following figure appears.
Figure 64. Generate FORM for "Customer" dialog box
The Generate FORM dialog box contains the following fields:
*Output File — Specifies the filename of the output file. The default filename is the table name with a .f extension.
*Fully Qualify Names — Specifies whether to qualify field names with table names (for example, table-name.field-name). The default value is No.
*Fully Expand Arrays — Specifies whether to fully expand arrays. For example, X[1] is expanded and X is not expanded. The default value is Yes.
*Frame Type — Specifies the type of frame to use. The options are Normal, Dialog, Overlay, or Top-Only. The default value is Normal.
*Formatting — Specifies the formatting to use. The options are Dictionary or Explicit. Dictionary specifies to use the Data Dictionary default formats without listing them in the FORM statement. Explicit specifies to explicitly list the format definitions in the FORM statement. The default value is Explicit.
*Validation — Specifies what type of validation to use. The options are Dictionary, Explicit, or None. The default value is Dictionary. Dictionary specifies to use the Data Dictionary default validation without listing them in the FORM statement. Explicit specifies to explicitly list the validation definitions in the FORM statement. None specifies that you do not want to use validation from the Dictionary or from FORM statements.
*Labeling — Specifies what type of labeling to use. The options are Dictionary, Explicit, or None. The default value is Explicit. Dictionary specifies to use the Data Dictionary default labels without listing them in the FORM statement. Explicit specifies to explicitly list the label definitions in the FORM statement. None specifies that you do not want to use any labels.
*Labels — Specifies the label position. The options are Side, Top, or None. The default value is Side.
The following figure shows an example of the FORM statement generated for the Customer table in the Sports database.
Figure 65. FORM statement example