Preface
Purpose
Audience
Organization
Using this manual
Typographical conventions
Examples of syntax descriptions
OpenEdge messages
Results Product Overview
Introduction
Database terminology
Database basics
Table relationships
Results overview
Query
Reports
Labels
Data export
User
Administration
Exit
Accessing Results help
Chapter summary
Getting Started
Installing and accessing Results
Overview
The DLCRES environment variable
The PROPATH environment variable
Progress startup parameters
Starting Results
Additional options to start Results
Results keystrokes
Window areas
Menu options
Information window
Layout window
Form window
Vertical menus, horizontal menus, and selection lists
Vertical menus
Horizontal menus
Selection lists
Where to go from here
A Tour Through Results
Introduction
Results tour preparations
Creating a copy of the sports database
Starting Results for the tour
Starting Results with a copy of the sports database
Starting Results from OpenEdge
Moving between Results and OpenEdge components
Query module features
Finding the next, prev, first, and last records
Selecting other records
Adding and deleting a record
Browsing through records
Joining files
Reports module options
Defining files and fields
Running a Report
Saving your report
Getting a report
Adding a math expression
Defining a new label and field format
Hiding repeating values and changing field formats and labels
Access the details you need to change
Hide repeating values, and change field formats and labels
Adding break groups, totals, and page ejects
Changing order of records
Adding total lines
Defining a page eject
Adding a WHERE clause
Adding a header to a report
Adjusting the spacing in a report
Data Export module tour
Selecting a data export type
Removing a WHERE clause
Labels module features
Adding text to a label
Adjusting settings
Stopping Results
Summary
Query Module
Before you begin
Introduction
Query option
Where option
Query module main menu
Query features
Updating a record
Copying a record
Switching to other forms
Querying for records
Using Expert mode in WHERE clauses
Getting information about the current set of records
Moving to another module
Finding the total number of records in a file
Changing the order of records
The User option
Summary
Reports Module
Before you begin
Introduction
Reports module main menu
Report markers
Report features
Adding fields to a report
Deleting fields from a report
Defining array fields for reports
Adding a header or footer to a report
Adjusting spacing in a report
Changing the order of records in a report
Adding a percent of total to a report
Getting information about the current report
Deleting a report
Adding a WHERE clause with Ask mode
Creating totals only reports
Defining totals only reports
Summarizing a non-numeric field
Expanding a report using the Totals Only Report
Summary
Labels Module
Before you begin
Introduction
Labels module main menu
Get
Put
Run
Define
Settings
Where
Order
Clear
Info
Module
User
Exit
Labels features
Saving label definitions
Getting label definitions
Copying label definitions
Running label definitions
Clearing and deleting label definitions
Defining labels manually
Adding text to labels
Adding fields to labels
Adjusting label settings
Omitting blank lines
Printing multiple copies
Changing the total height
Changing the top margin
Changing the text to text spacing
Changing the left margin indent
Changing the number of labels across
Summary
Data Export Module
Before you begin
Introduction
Data Export module main menu
Get
Put
Run
Define
Settings
Where
Order
Clear
Info
Module
User
Exit
Layout window settings
Data Export features
Adding fields to a Data Export report
Exporting reports in Progress format
Exporting data in other format
Exporting data in ASCII format
Using expert mode to change ASCII settings
Summary
Multiple Databases with Results
Before you begin
Introduction
Accessing multiple databases
Starting Results with multiple databases
Querying multiple databases
Joining file information
Adding fields to a report
Summary
Database Administration
Before you begin
General administration
When to edit the results.l file
Description of the initial build
Default forms
Where Results places the QC file
Logging initial build information
Default options
After the initial build
The Administration module
Application Rebuild option
Form Definitions for Query option
Add new query form
Choose query form to edit
General Form Characteristics
Which Fields on Form
Permissions
Delete Current Query Form
Relations Between Files option
Security options
Contents of a user directory
Exiting the application
Module permissions
Query permissions
Sign-on program/product name
Configuration options
Language
Printer setup
Add new output device
Choose device to edit
General device characteristics
Control sequences
Printer permissions
Delete current device
Terminal Color Settings option
Modules options
Browse Program for Query option
Default Report Settings option
User-defined Export Format option
Label field Selection option
User option
Summary
Integrating Results into Existing Applications
Before you begin
Introduction
Running Results from your own application
Tailoring the startup logo
Adding your own menu options to Results
Using customized help messages
Using shared variables
Testing the version number
Determining the originating module
Determining the video attributes
Determining the name of the originating program
Determining the order criteria defined
Determining files and selection criteria
Determining the fields selected for reports
Using Results dialog box procedures in your applications
Error message box
Logical choice box
Using the generated report, labels, and data export code
Designing your own export format
Designing your own print menu
Designing a browse program for query
Deploying applications that include a tailored Results interface
Configuration information
Query form information
Startup and Shutdown Procedures
Running Results in non-English languages
Starting Results from the Progress Procedure Editor
Starting Results with one database
Single-user mode
Multi-user mode
Starting Results with multiple databases
Single-user mode
Multi-user mode
Starting a server for the database
Shutting down a server for the database
Stopping Results
Option Descriptions
Menu options
Common menu options
Get
Put
Run
Where
Order
Clear
Info
Module
User
Exit Results
Menu options for the Query module
Next
Prev
First
Last
Add
Update
Copy
Delete
View
Browse
Join
Query
Where
Total
Order
Horizontal menu options for the Reports module
Define
Totals and subtotals
Running total
Percent of total
Counters
Math expressions (+ -*/)
String expressions
Numeric expressions
Date expressions
Settings
Center header
Right header
Left footer
Center footer
Right footer
First-page-only header
Last-page-only footer
Horizontal menu options for the Labels module
Define
Settings
Text‑to‑text spacing
Left margin indent
Number of labels across
Horizontal menu options for the Data Export module
Define
Width/Format of Fields
Settings
Field Display Formats
Introduction to the field display formats
Default display formats
Character display formats
Numeric display formats
Logical display formats
Date display formats
How to test and override default display formats
Results Limits
Results limits details
Files that Results Creates
Configuration file (.qc file)
Primary rule when editing the .qc file
Editing forms and joins
Order of options
Query log file (.ql file)
Query directory file (.qd file)
Users must have their own directories
Important lines in the .qd file
Scratch files
Order of Evaluation
Using expressions
Evaluating expressions
Rules
Helpful Information
Common problems during initial build
444 error
Too many joins
Limit on query forms: 63KB
Missing .qc file with multiple databases
Building in same directory as application
Overwriting customized query forms
When query forms do not compile
Missing validation files
Shared variable in validation expression
R-code greater than 63KB
Problems running a defined report
Language errors
Progress messages are not in correct language
Results not defaulting to correct language
Address fields in labels module default to wrong language version
OpenEdge® Reporting:Query/Results for UNIX
Language errors