Kbase P8435: ADM2. How to do a RIGHT join with SDO?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
ADM2. How to do a RIGHT join with SDO?
FACT(s) (Environment):
Progress 9.x
FIX:
The rules for using SmartDataObjects do not recommend using multiple in the same data source (SmartDataObject).
A better approach to use two separate SmartDataObjects (or a SmartBusinessObject).
For example, to use two SmartDataObjects in the following manner:
- 2 SmartDataObjects (1 on customers .. SDO1, one on invoices .. SDO2)
- 2 SmartDataBrowsers (B1 for customer based on SDO1 and B2 for Invoices based on SDO2)
Proceed as follows:
1) Place SDO1 in the first place into your SmartWindow
2) Place B1 and accept the links to SDO1
3) Place SDO2 into your SmartWindow, accept the link to SDO1
4) Place B2 into the SmartWindow and accept the link to SDO2
This should work and will allow you to navigate, once you select the customer in B1, all the related Invoices will show up in B2.