Kbase P157957: Error "Column not found/specified (7520) when specifying an extent for a hyphenated field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/01/2010 |
|
Status: Unverified
SYMPTOM(s):
Error "Column not found/specified (7520) when specifying an extent for a hyphenated field
Error 7520 when trying to access a specific extent in a field whose name contains a dash
Error 7520 when trying to access a specific extent in a field whose name contains a hyphen
Column not found/specified (7520)
=== SQL Exception 1 ===
SQLState=42S22
ErrorCode=-20006
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Column not found/specified (7520)
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column not found/specified (7520)
FACT(s) (Environment):
Example SQL-92 query:
SELECT "cust-num[1]" FROM pub.customer
Field name contains a dash/hyphen and therefore needs to be encapsulated within quotation marks
OpenEdge 10.1x
OpenEdge 10.2x
All Supported Operating Systems
CAUSE:
The extent specification is included within the quotation marks and is therefore treated as part of the field name
FIX:
Move the extent specification outside of the quotation marks. For example,
SELECT "cust-num"[1] FROM pub.customer