Kbase P13641: sql statement fails with /
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/01/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
Progress 9.0x
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
SQL statement fails with error.
Table/view/synonym not found (7519)
The field name specified in the where causes contained a / slash
CAUSE:
The SQL92 standard does not allow slashes in field names.
FIX:
The forward slash must be 'escaped' by putting the table name between double quotes.
Following is an example of correct syntax:
Select * from pub.customer Where "Order/Entry".