Kbase P29802: Can only parent records appear in a Browsed based against a
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2003 |
|
Status: Unverified
GOAL:
Can only one parent record appear in a Browsed based against a query on the child table?
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
Windows
FIX:
This type of left otter join on the master table can not be accomplished using normal SDO technology. A better methodology is to build two SDOs each with the best master table for the query within them or a Dynamic SDO. Then depending on the needed master table for the query you can use a radio set to bring the proper Browser into focus.
For example if you has an SDO with the Query "For Each Customer, Each Invoice of customer" and only wanted one specific invoice to be available in the browse, this could not be accomplished. They query will always display all customers and the resulting invoices that meet your query needs. Therefore a second SDO must be build using "For each Invoice, Each Customer of invoice". Then using the display and hide functions you can make the proper browse available for the right query.