Progress
Results Administration
and Development Guide
The Join Construction Dialog Box
The Join Construction dialog box allows you to build an expression that relates a base table to a second table. The expression that you build with the Join Construction dialog box is called a WHERE clause in the Progress 4GL. Regardless of whether you are adding a relationship or editing a relationship, the Join Construction dialog box is the only tool that supports these tasks. You can only access the Join Construction dialog box from the Table Relationships dialog box:
![]()
The Join Construction dialog box contains the following user-interface elements:
Join
Displays the current relationship. If you add a new relationship, the Join field displays the beginning of a WHERE clause that will eventually build a table relationship. If you edit an existing relationship, the Join field displays the relationship. If the existing relationship is an OF relationship, the Customize Join toggle box appears next to the Join field. You must activate Customize Join before you edit an OF relationship between two tables. Editing an OF relationship in the Join Construction dialog box changes the relationship to a WHERE relationship.
Second Table
Displays the fields of the second table.
Base Table
Displays the fields of the base table.
Operator Buttons
Comparison operators that you can use to build an expression between a field in the second table and a field in the base table. The AND and OR buttons represent logical operators that allow you to build compound expressions.
Join Criteria
Specifies the syntax that forms the WHERE relationship between the base and second tables. The following example of a WHERE clause relates a customer table with an order table:
For more information about the WHERE clause, see the FOR Statement reference entry in the Progress Language Reference.
Building a Table Relationship
Follow these steps to define a relationship between two tables in Results using the Join Construction dialog box:
- Activate the Customize Join toggle box if it is displayed in the Join Construction dialog box.
- Double-click a field from the second table. As you build the expression, the syntax of the expression appears in the Join Criteria area.
- Choose a comparison operator button.
- Double-click a field from the base table.
- If you want to build a more complex relationship, choose either the AND or OR operator button and return to Step 1.
- To save the current WHERE relationship and return to the Table Relationships dialog box, choose OK in the Join Construction dialog box.
Deleting a Table Relationship
Follow these steps to delete an existing table relationship from Results using the Table Relationships dialog box:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |