Kbase 41495: Error 7519 running an SQL92 query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P11495
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error running a query via SQL92.
Table/view/synonim not found (7519)
The name of the table being queried or updated contains a hyphen.
CAUSE:
The SQL92 standard does not allow hypens in table names.
FIX:
The hyphen must be 'escaped' by putting the table name between double quotes.
Following is an example of correct syntax:
SELECT * FROM "table-name-with-hyphens".
In case the table name must be qualified with a schema name, the syntax is:
SELECT * FROM PUB."table-name-with-hyphens".