Progress
Results Administration
and Development Guide


Database Configuration Files

When you first run Results against a database, the following message appears:

In this message, sports is the name of the database you are using to start Results. If you are starting Results with more than one database, only the name of the first database connected will appear in this dialog box.

The initial build creates a file called dbname.qc7. This query configuration file (QC7 file) contains the Results default settings for table relationships, security settings, label formats, export formats, and page formats. All the users who use Results with the specified database access this file. Results cannot run without the QC7 file. Therefore, if you are running Results for the first time against a new database or group of databases, Results must perform the initial build to create this file.

The QC7 file is named for the first database connected, so the order in which you connect databases when you start Results is important. For example, if you perform an initial build on the databases db1 and db2 (in that order), the QC7 file for these databases together is called db1.qc7. If you start Results with db2 and db1 (in that order), Progress returns a message that the db2.qc7 file was not found. If you start Results with only the db1 database, a message states that the database configuration has changed and requests you to rebuild the query configuration file.

NOTE: You can start Results with more databases than you used to build the QC7 file. However, the Query Site Admin Application Rebuild menu option causes Results to rewrite the entire QC7 file. When Results rewrites a QC7 file, it uses information from all connected databases.

The Location of the QC7 File

Results attempts to create the QC7 file in the same directory that contains the database (dbname.db). However, if the database is on another machine, and Results cannot locate that directory, Results places the QC7 file in the current working directory. Once Results creates a QC7 file, you can move it anywhere in your PROPATH.

When you start Results, it looks for the QC7 file in the current working directory. If it cannot find it there, it looks in the PROPATH. For more information about PROPATH, see the Progress Installation and Configuration Guide Version 9 for UNIX or Progress Installation and Configuration Guide Version 9 for Windows.

Query Configuration Log File

During the initial build and subsequent rewrites of a query configuration file, Results logs information in a query configuration log file (QL file). The name of the query configuration log file is dbname.ql, where dbname is the name of the first database connected for the session. The information in the query configuration log file can consist of compiler error messages and compilation times. Results creates the QL file in the same directory as the QC7 file.

Results continues to write to the QL file associated with a QC7 file for the life of the QC7 file. If the QL file becomes too large, simply delete the file. Results automatically creates a new QL file.

The results.l File and Initial Builds

Default information for a Results site is stored in the results.l file located in the aderes directory in the Progress product directory ($DLC\GUI). The results.l file is an ASCII file that contains the following default settings:

Results incorporates the contents of the results.l file into a QC7 file during initial build of the QC7 file. Subsequent rewrites of the QC7 file do not access the results.l file.

You can configure your default site settings by editing the contents of the results.l file prior to performing an initial build. Create a backup copy of the results.l file prior to editing it.

NOTE: If you introduce errors into the results.l file, you might encounter problems during the initial build of a QC7 file.

See "Results Files," for information about the contents of the results.l file.

After the Initial Build

After the initial build, you can use the Query Site Admin and Query Customize menus to override the default environment settings and customize Results for your own site. Most of these menu options edit the content of the current QC7 file. The remainder of this chapter describes how you can customize Results for your site using the Site Admin menu. See "Programming Results," for information about how you can extend and configure Results using the Customize menu.


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