Progress
Results User’s Guide
for Windows
Glossary
Aggregate FieldA 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.
ArrayA field or variable with multiple elements. Each element in an array has the same data type.
Ask At Run TimeA type of selection criteria in which part of the selection criteria is not known until run time.
AverageAn 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 GroupA 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 ViewA 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 FieldA field you create within Results to help you analyze the data in the query. Calculated fields are display fields only.
Comparison OperatorA symbol or word used to make comparisons. For example, LESS THAN (<), Equals (=), or GREATER THAN (>).
Complete RelationshipA 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 RecordA record that contain fields from more than one table.
Compound IndexAn index that is based on the value of two or more fields. See also Index.
ConstantA value that does not change.
Count AggregateAn aggregate field that calculates the number of records in a column of data, either by break group or for the entire report.
Cover PageText 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.
DataThe information stored in a database.
Data GovernorA feature that restricts the number of records reported to the user. The data Governor is available for Report, Label, and Export views.
Data SelectionThe process of defining selection criteria for a query.
DatabaseA collection of data organized in logically related tables or fields that can be accessed or retrieved. See also Data.
Display FieldA 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 ViewA Results view that formats records to export to other applications.
ExpressionA 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.
FieldA specific item of information. A record typically contains several related fields. See also Record.
Field DelimiterAn ASCII, decimal, hexadecimal, or octal code that marks the start and end of each field for exporting data to other applications.
Field SeparatorAn ASCII, decimal, hexadecimal, or octal code that distinguishes one field from the next for exporting data to other applications.
Final PageText 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.
FooterText that appears at the bottom of every page.
Form ViewA 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.
FrameAn area within a window where Results displays the contents of a query. A window can contain either one or two frames.
FunctionA prepackaged solution to a task that can be used in an expression.
Go-to LinkIn 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.
HeaderText that appears at the top of every report page.
Help TopicIn on-line help, displays information about one thing, such as a particular window or dialog box.
Hide Repeating ValuesA function that suppresses display of repeating or duplicate field values.
Hypertext LinkIn 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.
IndexA 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 ViewA Results view that formats and prints records in a variety of label formats, including mail and inventory labels.
Many-to-many RelationshipA 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-DetailA 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.
MinimumAn aggregate field that calculates the smallest value in a column of data, either by break group or for the entire report.
MaximumAn aggregate field that calculates the largest value in a column of data, either by break group or for an entire report.
One-to-many RelationshipA 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 RelationshipA table relationship that occurs when a record in one table can relate to only one record in another table. See also Table Relationship.
Online HelpA 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 RelationshipA 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 LinkIn 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 PreviewA window that shows the output from running a report or exporting a data file.
QueryA set of instructions that tells Results to locate data in one or more tables in your database.
Query ConfigurationA file that contains database and Results application settings used by all Results users. The query configuration file has an extension of
.qc7.
Query DirectoryA file that contains a list of queries for each user. The query directory field has an extension of
.qd7.
Query ExampleA 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.
RecordA collection of items of information called fields. A table typically contains many records that contain similar information.
Record EndAn ASCII, decimal, hexadecimal, or octal code that marks the end of each record for exporting data to other applications.
Record StartAn ASCII, decimal, hexadecimal, or octal code that marks the start of each record for exporting data to other applications.
Report ViewA Results view that creates multi-line and master-detail reports for printing. Provides calculated values and totals for thorough data analysis.
Selection CriteriaA 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-joinA table relationship in which a table is joined to itself. See also Alias.
Simple IndexAn index that is based on the value of one field. See also Index.
Sort OrderA user-defined order that determines the order in which Results retrieves records from the database.
Status BarThe 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.
SubexpressionAn expression within an expression.
SubtotalAn aggregate field that calculates a column of fields for each break group. See also Total.
TableA collection of related records organized into rows and columns. See also Record.
Table RelationshipDetermines 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 barA 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.
TotalAn 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 SummaryA Report and Export view setting in which numeric data values are summarized by break group, and only these summaries are displayed.
ViewA 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 ClauseA 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 |