Release 10.1A: OpenEdge Development:
AppBuilder

> ## Table mode

> In this mode, the Query Builder allows you to specify the tables you want in the query. When you modify a query from the property sheet of a frame or browse, the Query Builder also initializes to this mode. Figure 4–5 shows how the Query Builder appears in Table mode.

> Figure 4–5: Query Builder in Table mode

> To select a database table, select the table name in the Available Tables list and choose the Add button; you can also double-click on the name.

> To remove a table from the Selected Tables & Joins list, select the table name and choose the Remove button; you can also double-click on the name.

> After you select the tables you want, the AppBuilder displays the query in the Query panel. For example, if you choose the `Customer`, `Order`, and `Order-Line` tables, the Query field appears, as shown in Figure 4–6.

> Figure 4–6: Sample query for OF-joinable tables

> As you select tables, the AppBuilder establishes the relationship among them and the other tables that you have selected. If two tables share a common key with the same name and data type, they are `OF` joinable. If they are not `OF` joinable, you must establish how they will be joined. For example, if you choose the `Customer` and `Local-Default` tables, the AppBuilder displays the query in the Query panel, as shown in Figure 4–7.

>     FOR EACH sports.Customer NO-LOCK,
>       EACH sports.Local-Default WHERE TRUE /* Join to Customer incomplete */
>     NO-LOCK:

> Figure 4–7: Query sample with incomplete join criteria

> The comment indicates that you must complete the relationship of the `Local-Default` table to the `Customer` table. Complete the join criteria by choosing the Join button to enter Join mode.

> If you select three or more tables and AppBuilder can establish the relationship among them, the AppBuilder still allows you to choose a table and change its join criteria. You do this by selecting the table in the Selected Tables & Joins list and choosing the Switch Join Partners button.

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