Progress
Basic Database
Tools
Utilities>Generate Include Files
Choose this option to quickly prepare an include file to store Progress language statements. Because the ASSIGN, FORM, and DEFINE WORK-TABLE statements can be long and complicated, you might want to store them in an include file. Also, particular instances of these statements are often repeated in different procedures, and using an include file lets you easily insert them into any Progress procedure. See the following reference entries in the Progress Language Reference for more information: { }Include File, ASSIGN statement, FORM statement, and DEFINE WORK-TABLE statement.
Table 11–4 describes the menu that appears when you choose this option. More detailed descriptions of the options follow the table.
Generate Include Files
ASSIGN Statement
Use this option to generate an ASSIGN statement to copy a table. Progress alphabetically lists all the tables defined for your database. When you choose a table, Progress prompts you for the filename of the output file. The default filename is table-name.i. Progress creates an output file that contains an ASSIGN statement to copy each field of the table from one buffer record to another and prompts you to continue.
Figure 11–6 shows an example of the ASSIGN statement generated for the customer table in the sports database.
Figure 11–6: ASSIGN Statement Example
![]()
Generate Include Files
FORM Statement
Choose Generate Include Files
FORM Statement to generate a FORM statement for a table. Progress alphabetically lists all the tables defined for your database. When you select a table, the Generate FORM dialog box shown in Figure 11–7 appears.
Figure 11–7: Generate FORM Dialog Box
![]()
This dialog box contains the following user-interface elements:
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 (that is, 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 nor 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 any use labels, that is Progress adds NO-LABELS to the WITH phrase of the FORM statements.
Labels
Specifies the label position. The options are Side, Top, or None. The default value is Side.
Figure 11–8 shows an example of the FORM statement generated for the customer table in the sports database.
Figure 11–8: FORM Statement Example
![]()
Generate Include Files
DEFINE WORK-TABLE Statement
Use this option to generate a DEFINE WORK-TABLE statement for a table. Progress alphabetically lists all the tables defined for your database. When you choose a table, Progress prompts you for the filename of the output file. The default filename is table-name
.i
. Progress displays a status message and prompts you to continue.Figure 11–9 shows an example of the DEFINE WORK-TABLE statement generated for the customer table in the sports database.
Figure 11–9: DEFINE WORK-TABLE Statement Example
![]()
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |