Kbase P75433: Dynamic Combo and Dynamic Lookup linked by parent field fail to open lookup query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/6/2004 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.1A
SYMPTOM(s):
Dynamic Combo and Dynamic Lookup linked by parent field fail to open lookup query
The Parent Dynamic combo can be changed, but the child lookup fails to show the correct subset of records.
** Unable to understand after -- "ItemNum = 0) AND". (247)
** Cannot understand expression involving AND operator. (249)
PREPARE syntax is: {FOR | PRESELECT} EACH OF .. WHERE ... etc". (7324)
** Unable to understand after -- "<table-name>". (247)
** Cannot understand expression involving AND operator. (249)
PREPARE syntax is: {FOR | PRESELECT} EACH OF .. WHERE ... etc". (7324)
CAUSE:
The definition of the parent filter query is incorrect.
With a simple base query of 'FOR EACH tablename NO-LOCK', and a parent filter query of the form "AND tablename.fieldname = INTEGER('&1')" results in a query evaluated to:
'FOR EACH tablename WHERE AND <selection phrase> NO-LOCK'
FIX:
Remove the AND phrase from the parent filter query.