Kbase P109528: SQL92 query fails with error 7520 column not found though column is valid
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/16/2008 |
|
Status: Verified
SYMPTOM(s):
SQL92 query fails with error 7520 column not found though column is valid
Column not found/specified (7520)
Select statement sample used is:
select * from pub.customer where name = "Lift Tours"
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The usage of double quote marks is meant for tables and fields not data values for comparison.
FIX:
Use single quotes around the value for comparison.
Example:
select * from pub.customer where name = 'Lift Tours'