Kbase P21226: startSearch on Calculated columns in Dynamic lookup browser
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/31/2003 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.0A
SYMPTOM(s):
Dynamics 2.0A01
startSearch event fires (click on column label)
Calculated columns in browser of a Dynamic lookup
QUERY-PREPARE requires a valid non-null character argument for query . (7321)
QUERY-OPEN for query requires a previous QUERY-PREPARE. (7312)
Invalid use of browse method SCREEN-VALUE. There are no selected rows. (382)
CAUSE:
Indeed, the startSearch event is used to change the BY clause of query in order to sort the query on the selected column. This is a feature of the DynBrowse. (in browse.p). However, sorting on a calculated field in a DynLookup has not been implemented in the frame work yet.
FIX:
Suggestion:
It might be possible to get rid off this error by making an override of StartSearch for the lookup. In the override, rely on phBrowse:CURRENT-COLUMN (see input param browse.p/StartSearch) to determine whether it is a calculated field column or not. If no then do RUN SUPER (phBrowse), else do the following to not do anything and get rid off the error:DO:
APPLY 'END-SEARCH':U TO phBrowse.
RETURN.
END.