Kbase P148183: Error 10713 Querying Table Named "show"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/06/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 10713 Querying Table Named "show"
Error Source: Microsoft OLE DB Providers for ODBC Drivers
Syntax error at or about (statement excerpt). (10713)
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about ".show" (10713)
FACT(s) (Environment):
The same statement worked against V9 database using V9 ODBC and JDBC driver
All Supported Operating Systems
OpenEdge 10.2x
CAUSE:
"show" is a reserved keyword in OE, and it was not a keyword in V9
FIX:
Double quote the table name "show" in the query