Kbase P10071: Dynamics: Errors 250 and 247 with Dynamic Lookup Parent Filter query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/24/2009 |
|
Status: Unverified
SYMPTOM(s):
Dynamics: Errors 250 and 247 with Dynamic Lookup Parent Filter query.
** unable to understand after --"AND (NAD_Obj eq''.(247)
** Cannot process comparison in expression. (250)
PREPARE syntax is: {FOR | PRESELECT} EACH OF .. WHERE ... etc". (7324)
Adding a parent filter query to a dynamic lookup property sheet results in the above two errors at runtime when the object is initialized.
FACT(s) (Environment):
Dynamics Beta 2
Dynamics 2.0A
FIX:
1. The parent filter query needs to have the field name with the table prefix. So, for example "language_obj = &1" becomes "gsc_language.language_obj = &1".
2. All field values are returned as CHARACTER, so a conversion function in front of the substitution character is required. Therefore, "gsc_language.language_obj = &1" becomes "gsc_language.language_obj = DECIMAL('&1')".
3. Since &1 will be substituted with the SCREEN-VALUES returned for the specified parent field, language_obj needs to be on the viewer (which it is not when creating the viewer from the object generator).