Kbase P122665: SQL CASE statement examples in SQL Reference manual contain syntax errors
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/03/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.0x
OpenEdge 10.1A
OpenEdge 10.1B
SYMPTOM(s):
SQL CASE statement examples in SQL Reference manual contain syntax errors
Example 3:
select lastname, city,
case
when state = 'MA' then 'In Mass' else 'Not in Mass'
end
from supplier;
Example 4:
select lastname, city
case state
when 'MA' then 'In Mass' else 'Not in Mass'
end
from supplier;
CAUSE:
This is a known issue being investigated by Development
FIX:
In both examples, the field "lastname" should be "name".
In example 4, there should be a comma after the "city" field.