Kbase P76177: Running a select statement in SQL Explorer fails with error (7519).
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/2/2009 |
|
Status: Verified
SYMPTOM(s):
Running a select statement in SQL Explorer fails with error (7519).
SQLState=42S02
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
CAUSE:
The specified name has hyphens.
FIX:
Enclose the hyphenated table name in double quotes:
For example:
select * from PUB.cust-ar
change to:
select * from PUB."cust-ar"