Progress
AppBuilder
Developer’s Guide


Join Mode

When you activate the Join radio-set button in the Query Builder dialog box, you enter Join mode, and the Query Builder appears as in Figure 4–8.

Figure 4–8: Query Builder in Join Mode

To enter this mode, you must already have selected at least two database tables. If you select more than two tables, you can use the down arrow button in the Join combo box to choose the combination of tables you want to join.

If two tables are OF joinable, you can change their join criteria by activating the Customize Join toggle box to establish a WHERE clause between the two tables. Your comparison options are equal, not equal, less than, greater than, less than or equal, and greater than or equal. To use one of these options, double-click in a field from one of the tables, double-click on one of the comparison buttons, then click in another field from the other table.

As you establish comparisons between fields, the AppBuilder displays the 4GL code in the Join Criteria panel. When you choose OK, the AppBuilder displays the code in the Query Builder’s Query field (and in the widget’s property sheet, if the query is an embedded one). You can link the comparisons with AND or OR.

If you are familiar with the Progress 4GL, you can edit the Join Criteria field by clicking in it and typing in the code directly.


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