Kbase P16267: Two SmartDataObjects w/Foreign Key relationship shows no data in child after setQueryWhere invoked i
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Using ADM2
Has two SmartDataObjects connected via a foreign key relationship
Selecting a new record in the parent SmartDataObject shows no related records from the child SmartDataObject
CHANGE:
Added code which changes the query of the child SmartDataObject via the setQueryWhere function
CAUSE:
The setQueryWhere function appends to the existing query and the resulting "new" query string caused all records to be filtered out.
FIX:
After manually changing the query of the child SmartDataObject and doing whatever processing is required, reset the query to its default query by running the following code:
DYNAMIC-FUNCTION('setQueryWhere':U IN <SomeSDOHandle>, INPUT '').