Kbase 33739: Syntax error (7587) when querying SQL-92 Table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P3739
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
using SQL-92
Syntax error (7587)
Syntax error when querying SQL-92 Table
CAUSE:
A SQL-92 Reserved Word was not in quotes
FIX:
Any Fields or Tables that are part of SQL-92 Reserved Words should be quoted.
Example : select "date" from pub.theTable;