Progress
Results User’s Guide
for Windows


Glossary

Aggregate Field

A field that calculates the value of a column of fields. If break groups are used, calculates the value of a column of fields for each break group. Results calculates the following aggregates: total, count, minimum, maximum, and average.

Array

A field or variable with multiple elements. Each element in an array has the same data type.

Ask At Run Time

A type of selection criteria in which part of the selection criteria is not known until run time.

Average

An aggregate that calculates the average value (sum of values divided by the number of records) in a column of data, either by break group or for the entire column.

Break Group

A set of records that have a common value in a certain database field. Break groups are used in reports to display table and record relationships.

Browse View

A Results view that displays a query on your computer screen. The Browse view lists records online in a tabular format similar to a spreadsheet.

Calculated Field

A field you create within Results to help you analyze the data in the query. Calculated fields are display fields only.

Comparison Operator

A symbol or word used to make comparisons. For example, LESS THAN (<), Equals (=), or GREATER THAN (>).

Complete Relationship

A type of relationship or join. When used in a query that accesses two or more tables, a complete relationship instructs Results to access all the records in the first table whether or not they have related records in the second table. See also Partial relationship.

Composite Record

A record that contain fields from more than one table.

Compound Index

An index that is based on the value of two or more fields. See also Index.

Constant

A value that does not change.

Count Aggregate

An aggregate field that calculates the number of records in a column of data, either by break group or for the entire report.

Cover Page

Text that appears on the very first page of a report as a separate page, before the first data record is processed. The cover page does not contain any report data.

Data

The information stored in a database.

Data Governor

A feature that restricts the number of records reported to the user. The data Governor is available for Report, Label, and Export views.

Data Selection

The process of defining selection criteria for a query.

Database

A collection of data organized in logically related tables or fields that can be accessed or retrieved. See also Data.

Display Field

A field in the query that is displayed in the query views as opposed to a field in the query that is not displayed in the query views.

Export View

A Results view that formats records to export to other applications.

Expression

A combination of constants, variables, operations, and parentheses used to perform a calculation. An expression can consist of anything from a single constant or variable to a complicated arrangement of operators and functions that fit into a single clause.

Field

A specific item of information. A record typically contains several related fields. See also Record.

Field Delimiter

An ASCII, decimal, hexadecimal, or octal code that marks the start and end of each field for exporting data to other applications.

Field Separator

An ASCII, decimal, hexadecimal, or octal code that distinguishes one field from the next for exporting data to other applications.

Final Page

Text that appears on the very last page of a report, after all the data records have been processed. The final page does not contain any report data.

Footer

Text that appears at the bottom of every page.

Form View

A Results view that displays a query on your computer screen. The Form view allows you to view, update, add, and delete records in the database.

Frame

An area within a window where Results displays the contents of a query. A window can contain either one or two frames.

Function

A prepackaged solution to a task that can be used in an expression.

Go-to Link

In online help, a hypertext link that displays a new help topic. A go-to link is a word or phrase set apart from the surrounding text by a solid underline. See also Hypertext Link.

Header

Text that appears at the top of every report page.

Help Topic

In on-line help, displays information about one thing, such as a particular window or dialog box.

Hide Repeating Values

A function that suppresses display of repeating or duplicate field values.

Hypertext Link

In online help, an underlined word or phrase that accesses related information. There are two types of hypertext links: pop-up links and go-to links. To display the information associated with a hypertext link, click the underlined topic. See also Pop-up Link and Go-to Link.

Index

A list that contains a value for each record in a table. Indexes let you sort, process, and search for records in a table quickly and efficiently.

Label View

A Results view that formats and prints records in a variety of label formats, including mail and inventory labels.

Many-to-many Relationship

A table relationship that occurs when many records in one table can relate to many records in a second table; and many records in the second table can relate to many records in the first table. See also Table Relationship.

Master-Detail

A feature whereby a multi-table, single-selection report is split into two sections. Master-Detail is especially useful for eliminating duplicate, repeating values in a report. See also Hide Repeating Values.

Minimum

An aggregate field that calculates the smallest value in a column of data, either by break group or for the entire report.

Maximum

An aggregate field that calculates the largest value in a column of data, either by break group or for an entire report.

One-to-many Relationship

A table relationship that occurs when a record in one table can relate to many records in another table. See also Table Relationship.

One-to-one Relationship

A table relationship that occurs when a record in one table can relate to only one record in another table. See also Table Relationship.

Online Help

A feature that lets you get information about the Results application from within Results. On-line help contains descriptions of the Results windows and dialog boxes and explanations of how to use the features available within Results.

Partial Relationship

A type of relationship or join. In a query that accesses two or more tables, a partial relationship instructs Results to access only those records in the first table that have related records in the second table. See also Complete Relationship.

Pop-up Link

In online help, a hypertext link that displays a definition. A pop-up link is a word or phrase set apart from the surrounding text by a dotted underline. See also Hypertext Link.

Print Preview

A window that shows the output from running a report or exporting a data file.

Query

A set of instructions that tells Results to locate data in one or more tables in your database.

Query Configuration

A file that contains database and Results application settings used by all Results users. The query configuration file has an extension of .qc7.

Query Directory

A file that contains a list of queries for each user. The query directory field has an extension of .qd7.

Query Example

A dialog box that prompts the user for data selection values in-situ, that is directly in the field fill-in involved in the data selection.

Record

A collection of items of information called fields. A table typically contains many records that contain similar information.

Record End

An ASCII, decimal, hexadecimal, or octal code that marks the end of each record for exporting data to other applications.

Record Start

An ASCII, decimal, hexadecimal, or octal code that marks the start of each record for exporting data to other applications.

Report View

A Results view that creates multi-line and master-detail reports for printing. Provides calculated values and totals for thorough data analysis.

Selection Criteria

A user-defined criteria that determines which records the query returns from the database and the order in which it returns them. The criteria for the query is displayed in the Criteria field in the query window.

Self-join

A table relationship in which a table is joined to itself. See also Alias.

Simple Index

An index that is based on the value of one field. See also Index.

Sort Order

A user-defined order that determines the order in which Results retrieves records from the database.

Status Bar

The horizontal line at the bottom of the Results window that contains informational messages about the current status of Results, including the database you are connected to and the query view you are using.

Subexpression

An expression within an expression.

Subtotal

An aggregate field that calculates a column of fields for each break group. See also Total.

Table

A collection of related records organized into rows and columns. See also Record.

Table Relationship

Determines the set of records returned in a query containing two or more tables. There are two types of table relationships: complete or partial. See also Complete Relationship and Partial Relationship.

Tool bar

A linear series of buttons that allows the user to quickly perform a function. The most commonly used functions or features are usually represented on the tool bar.

Total

An aggregate field that calculates an entire column of fields whether or not the fields are displayed within break groups. Also, a specific type of aggregate that sums the value of each field in a column. See also Subtotal.

Totals Only Summary

A Report and Export view setting in which numeric data values are summarized by break group, and only these summaries are displayed.

View

A method for displaying and processing the data retrieved by a query. Results provides you with the following views: Browse, Report, Form, Labels, and Export. Depending on the view you use, you can scroll through the data, update the data, generate reports and mailing labels, or export the data to other applications.

WHERE Clause

A phrase that lets you limit the set of data returned by a query.


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