Kbase P113169: How to define a join between two tables in an SDO using the AppBuilder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/02/2006 |
|
Status: Unverified
GOAL:
How to define a join between two tables in an SDO?
FIX:
Following are the steps involved in defining a join between two tables in the same SDO at design time using the AppBuilder:
1. Choose the 'Define Query' button from Page 2 of 4 of the SmartDataOBject Wizard to access the Query Builder dialog box.
2. Double-click on the two tables to join from the 'Available Tables' selection list of the Query Builder dialog box.
3. Check the 'Join' radio-set button in the Query Builder dialog box to enter the 'Join Mode'.
4. Double-click a field from the first table.
5. Double-click on one of the comparison buttons (=, <>, etc.).
6. Double-click a field from the second table.
7. Click OK button to return to Page 2 of 4 of the SmartDataOBject Wizard.
8. Examine the generated 4GL Query for accuracy, then click Next button to access Page 3 of 4 of the SmartDataOBject Wizard.
7. Click Add Fields button access the Column Editor dialog box.
8. Click the Add Button in the Column Editor dialog box to access the Multi-Field Selector dialog box.
9. Add the desired fields by double clicking on them individually in the 'Available Fields' selection list or by selecting them first and clicking the 'Add' button.
10. Click OK to return to the Column Editor dialog box.
11. Click OK to return to Page 3 of 4 of the SmartDataOBject Wizard.
12. Click Next to move to Page 3 of 4 of the SmartDataOBject Wizard.
13. Click Finish to close the SmartDataOBject Wizard.
14. Save the SDO.