Kbase P3739: Syntax error when a query contains SQL-92 reserved keywords
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/11/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Error querying database with SQL-92
Syntax error (7587)
Syntax error at or about (statement excerpt). (10713)
Syntax error when querying SQL-92 table
The query contains SQL-92 reserved keywords
CAUSE:
A SQL-92 reserved keyword was not put between quotes.
FIX:
Any fields or tables that are part of SQL-92 reserved keywords should be quoted.
Example : select "date" from pub.theTable;
Please refer to SQL-92 Guide and Reference for a complete list of reserved SQL-92 keywords.