Kbase P97250: Select statements fails when a hyphen is contained in the field or table name
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/12/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Select statements fails when a hyphen is contained in the field or table name
Cannot query table names and/or field names that contain hyphens in SQL statements
Table/View/Synonym not found (7519)
How to work around - hyphens in table or field names in SQL-92?
Using SQL-92
Select statements return data when tables and field names do not contain hyphens
CAUSE:
Dashes or hyphens in table or field names are considered special characters.
FIX:
There are two ways to reference a table or field name with dashes or hyphens:
1. Use double quote on table names
For Example:
Select * from pub."Customer-Name";
2. Create a view to reflect the same table with all the fields selected