Subject | Problem with CASE. |
---|---|
Author | João Luiz |
Post date | 2010-08-18T16:12:38Z |
Hi all!
It's my first message in the list.
I'm trying to execute this query on Firebird:
select id, case id when 70 then 'oi' end as caso from movimentacao;
And it returns an SQL error (-104) on the 'when' command.
I also tried:
select id, case when id=70 then 'oi' end as caso from movimentacao;
And got the same error.
Thx!
[Non-text portions of this message have been removed]
It's my first message in the list.
I'm trying to execute this query on Firebird:
select id, case id when 70 then 'oi' end as caso from movimentacao;
And it returns an SQL error (-104) on the 'when' command.
I also tried:
select id, case when id=70 then 'oi' end as caso from movimentacao;
And got the same error.
Thx!
[Non-text portions of this message have been removed]