Kbase P48439: Errors 247 and 7324 with Dynamics dynamic Lookup
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/16/2005 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.0A
SYMPTOM(s):
Errors 247 and 7324 with Dynamics dynamic Lookup
** Unable to understand after -- "table-name NO-LOCK". (247)
PREPARE syntax is: {FOR | PRESELECT} EACH OF..WHERE...etc".(7324)
Building a Dynamic Lookup with the Query Builder, when the Lookup is initialized at runtime results in the 247 and 7324 errors.
CAUSE:
Known issue.
FIX:
Manually remove the spaces and carriage return characters added in the query by the query Builder. So for example a query such as:
FOR EACH CFGE NO-LOCK,
EACH gsc_entity_mnemonic WHERE gsc_entity_mnemonic.entity_mnemonic = CFGE.ENTITY_MNEMONIC NO-LOCK
BY CFGE.ENTITY_MNEMONIC INDEXED-REPOSITION
Should be as if the query is on a single line:
FOR EACH CFGE NO-LOCK,EACH gsc_entity_mnemonic WHERE gsc_entity_mnemonic.entity_mnemonic = CFGE.ENTITY_MNEMONIC NO-LOCK BY CFGE.ENTITY_MNEMONIC INDEXED-REPOSITION