Kbase P155286: Trying to create a View generates errors 247 and 198
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/28/2010 |
|
Status: Unverified
SYMPTOM(s):
Trying to create a View generates errors 247 and
** Unable to understand after -- "<string>". (247)
** <program> Could not understand line <number>. (198)
Sending SQL from Procedure Editor
UNION operator is used in query
FACT(s) (Environment):
Windows
OpenEdge 10.2A
CAUSE:
Syntax used to build SQL statement is for SQL-92. Procedure Editor does not support SQL-92.
FIX:
Use SQL-89 syntax from Procedure Editor.