Kbase P50298: AssignQuerySelection does not work with calculated fields.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/29/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
AssignQuerySelection does not work with calculated fields.
CAUSE:
AssignQuerySelection cannot work with calculated fields because the value of each calculated field needs to be evaluated before the filter can be applied.
FIX:
A possible workaround is to base the SDO on a temp table and evaluate the calculated fields as the temp table is populated. The filter can then be applied to the temp table after the temp table is built.