Release 10.1A: OpenEdge Reporting:
Query/Results for UNIX

> ## Form Definitions for Query option

> Use the Form Definitions for Query option to define and modify query forms. When you select the option, the screen in Figure 9–4 appears.

> Figure 9–4: Defining forms for the query module

> Use this option if you want a file or field added after the initial build to appear in the query forms you built.

> You must select Add New Query Form or Choose Query Form to Edit before you can specify update information. After you add or edit a query form and press END to exit, Results prompts you to compile the changed form now, or to perform an application rebuild later.

> The options under the Form Definitions for Query option follow.

> ##### Add new query form

> Select this option, then select the file you want to use to build a query interface. The list contains only the files you can read, that is, you have CAN-READ permissions established in the OpenEdge Data Dictionary. An asterisk (*) marks any file that has query interfaces built on it.

> Once you select a file, you must enter the following information or accept the default information:

> - Query program filename — This is the name of the procedure that Results generates from the file definitions you supply. If you add a new query procedure and give it a name that already exists, you receive a warning that Results will overwrite the existing procedure. You can change the program name at this prompt.

> - Form physical filename — This is the name of the operating system file that contains the form definition for the query interface.

> If you have a program form you want to use, enter it here. If a form with this name already exists, you can use the fields from this form. Results parses the existing form code and presents a list of the fields from that form.

> If you do not want to use an existing form, enter a new filename. Results prompts you to generate a new form. If you select YES, you see a list of all the fields from that file that you have CAN-READ permissions for, as established in the OpenEdge Data Dictionary. You select the fields according to the criteria described in this section (entering YES or NO at the prompts).

> From this list, you determine the fields you want to display, update, or query. You also determine the fields you want in the browse list. In the forms list, the fields appear along the left side of the window. There are five columns to the right of the field names. The first four columns are: Disp? (display), Upd? (update), Qry? (query), and Brow? (browse). Each column has a yes or no value. The fifth column is Seq (sequence); it takes a numeric value.

> - Display — Determines if the field appears in the query form. Enter YES if you want it in the form. If you enter NO, the field and its label do not appear in the query form. You must answer YES if you want to enable the Update or Query option or give the field a sequence value.

> - Update—Determines whether the field can be updated. If you enter No, the field becomes read-only.

> - Query—Determines if the Query option is enabled on this field during a dynamic lookup.

> - Browse—Determines if the field appears in a browse list.

> - Sequence—Determines the order in which fields appear in the form.

> - Frame name for the Progress 4GL code. If you use your own form and you named a
>   frame in the form definition, you must enter that frame name here. For information about designing forms, see the OpenEdge Development: Progress 4GL Handbook .
> - Description. A line of text that describes the information contained in the query form. This description is what the user sees when selecting from the query form list.

> ##### Choose query form to edit

> Presents a list of existing forms. After you choose a form to edit, you can set the General Form Characteristics.

> ##### General Form Characteristics

> Use this option to change the frame name that your form references and the description of the form that appears in the Query Form List when the user selects the Query option.

> ##### Which Fields on Form

> Use this option to select the fields to display on the query interface, the fields that can be updated or queried, the fields that appear on the browse list, and the order in which the fields appear. When you select this option, the fields appear that you selected with the Choose Query Form to Edit or the Add New Query Form option.

> Results uses two form types: default and user. Results uses the default form type for the query interface unless you use the Manual option to build your interface with Results, add a new form through the Administration module, or enter the name of an existing form. In those cases, Results uses the user form. Thus, you can reference the form from the query interface (the `.f` file from the Form physical filename option) to define other query interfaces. When you choose the Add New Query Form option and use the fields from an existing form definition (`filename``.f`) to define your new query interface, by default the query form you define is the user type. When forms have the user type, your changes do not affect the actual form definition; they only change the way the fields appear on the query interface.

> If the generated form is too large to fit on a 24 by 80 screen, you see a warning message. (The message tells you the size of the form.) You can continue and build the form, but you receive a run-time error if you try to run it on a 24 by 80 screen. However, you can run it on a screen large enough for the form.

> ##### Permissions

> Use this option to limit access to any query form. See the "Security options" section for information about setting permissions.

> ##### Delete Current Query Form

> Use this option to remove query forms from the list of available forms. Results deletes the procedure, include, and object files related to the query form you delete. It also deletes the form definition file if Results created it (the default). However, it will not delete the definition file if you created it. If you want to delete a file you created, you must delete it yourself.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095