Kbase P26013: Error 7520 when running a SQL-92 query when field in the WHE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/31/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Running SQL-92 query
Field name in the WHERE clause contains a hyphen (-)
Date field enclosed in double quotes ("")
CAUSE:
This error behaviour is consistent with 2 causes:
1. The field name contains a hyphen, but is not enclosed within double quotes.
2. The date field is enclosed in double quotes instead of single quotes
FIX:
1. Ensure that any field name containing a hyphen is included in double quotes.
2. Ensure that date fields are enclosed in single quotes.
The following illustrates the correct syntax:
select * from pub.invoice where "invoice-date" = '1993-02-08'