Kbase P104176: Error 7587 with an SQL statement on tables and fields names containing hyphens and underscores
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/06/2010 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Error 7587 running an SQL92 statement
Syntax error (7587)
Other errors may appear, depending on the tool used to run the statement
Table and/or field names contain hyphens and/or underscore characters
Select statements querying meta schema tables also fail.
CAUSE:
Under SQL92, neither table names nor field names may contain hyphens or underscore characters, although the Progress 4GL allows to create table and field names with those characters.
FIX:
Enclose the table or field names in double quotes, as in the following examples:
SELECT "cust-num" FROM PUB.customer;
SELECT "_name" from pub."_file";