Kbase P3740: Error 196 occurs against FOR EACH referencing SCREEN-VALUE in MS SQL & Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1C
Oracle DataServer
MS SQL DataServer
SYMPTOM(s):
** Could not understand line. (196)"
Running a code containing join as follows:
FOR EACH customer NO-LOCK
WHERE customer.name BEGINS customer.name:screen-value,
EACH order OF customer NO-LOCK
WHERE order.instructions BEGINS order.instructions:
Does not occur against a Progress database
Does not occur against a AS/400 database
FIX:
To workaround the problem, use the QUERY-TUNNING(NO-JOIN-BY-SQL-DB).
DO:
FOR EACH CUSTOMER NO-LOCK
WHERE CUSTOMER.NAME BEGINS CUSTOMER.NAME:SCREEN-VALUE,
EACH ORDER OF CUSTOMER NO-LOCK
WHERE ORDER.INSTRUCTIONS BEGINS
ORDER.INSTRUCTIONS:SCREEN-VALUE
QUERY-TUNING(NO-JOIN-BY-SQL-DB):
END.