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

> ## Default forms

> If you select the AUTO build option or the SEMI build option on the Query forms window shown in Figure 9–2, Results automatically determines all defaults. However, after the initial build completes, you can change defaults using the Administration module. This section describes how Results determines default settings.

> Results assumes a screen size of 80 characters wide by 24 lines high, with 17 of the 24 lines available to users. When you build your query interface form, it must fit within these constraints.

> If you select AUTO during an initial build, Results builds an interface according to the following rules:

> - Results drops any field with a display format greater than 76 characters. (Results uses two spaces for attribute characters and two for the box (frame edge), so it interprets any field wider than 76 characters as wider than 80 (that is, 76 + 4). Therefore, any field interpreted as greater than 80 characters wide is dropped.)

> - If all the fields do not fit in the format, Results sorts them in descending order by size. Size is determined according to this formula:

>     field width + label width [+ extent of array]

> After determining the size of the fields, Results drops the largest field with the highest order value (as taken from the OpenEdge Data Dictionary). For example, if your last two fields have an order value of 60 and 70, and field 60 contains 35 characters while field 70 contains 15 characters, Results drops the field with the order value 60. If this field is an array element, it drops the whole array.

> To see if Results dropped any fields while building a form, look in the query log (`QL`) file. (See the "Logging initial build information" section for more information about this file.)

> For each query form, Results creates a procedure file that contains the actual query procedure, an include file called by the procedure, and a form definition file for the query. It places these files in the current directory, but you can move them anywhere in the `PROPATH`.

> By default, the output filenames are `filename``.p`, `filename``.i`, and `filename``.f`, where `filename` is the first eight characters of the filename. If there is a procedure anywhere in the `PROPATH` with the same name, the new output file takes the name `qry` `xxxxx``.p`, `qry` `xxxxx``.i`, and `qry` `xxxxx``.f`, where `xxxxx` represents an integer value that is unique to the `PROPATH`. When renaming occurs, the change is logged to the QL file. The "Logging initial build information" section section describes the QL file.

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