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.

Table 11–4: Generate Include Files Menu 
Generate Include Files
ASSIGN Statement ...
Generates an ASSIGN statement to copy a table.
FORM Statement ...
Generates a FORM statement for a table.
DEFINE WORK-TABLE Statement ...
Generates a WORK-TABLE statement for a 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