Kbase P83695: QUERY/RESULTS Error: ** Phrase or option conflicts with previous phrase or option. (277)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/08/2004 |
|
Status: Unverified
SYMPTOM(s):
** Phrase or option conflicts with previous phrase or option. (277)
You gave two mutually exclusive syntax constructs. For example: INPUT FROM ABC ECHO NO-ECHO. Use statement HELP for the statement that caused this error to make sure all the phrases you gave are in the right order, you did not use both alternatives of a pair of options controlling the same feature, or you did not use a single phrase multiple times.
** Unable to understand after -- "<string>". (247)
PROGRESS only understood a part of a statement. Look carefully at your procedure and at <string>. The problem should be in the next word or special character after <string> ends. Check the previous statement for a missing terminator (period or colon). Check for misplaced keywords or constants that are missing quotes.
** <program> Could not understand line <number>. (198)
This is probably a syntax problem. Check this statement and the previous one for proper termination (a period followed by a space, or a colon followed by a space for block statements). Also, check for misplaced reserved keywords (AVAILABLE, INDEX, HEADER, etc.) and for constants (quoted strings, numerals, dates) where field, file and frame names should go, and vice versa.
Errors generated while defining a new table relationships in CHUI character RESULTS running on UNIX. The WHERE phrase was entered as:
line 1: WHERE Table1.Field1 = Table2.Field1
line 2: WHERE Table1.Field2 = Table2.Field2
line 3: WHERE Table1.Field3 = Table2.Field3
CAUSE:
Wrong syntax in entering the 'WHERE' phrase. Only one 'WHERE' is needed on line 1 and an 'AND' operator should be added at the end of line 1 and line 2.
FIX:
The correct syntax is:
line 1: WHERE Table1.Field1 = Table2.Field1 AND
line 2: Table1.Field2 = Table2.Field2 AND
line 3: Table1.Field3 = Table2.Field3