@Alan

I tried this way too, do not work, only on ISQL.

@Hans

Online work on ISQL.

@All

My database have 7-zipped 34 Kb, I can upload this to my ftp with it help to find the problem.
I'm going crazy, everything just work on ISQL.


From: Alan McDonald
Sent: Wednesday, August 18, 2010 7:16 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Problem with CASE.



Your picture shows you are using
SELECT TIP_ID CASE TIP_ID WHEN

this is wrong, use
SELECT TIp_ID, CASE WHEN
Alan

> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of João Luiz
> Sent: Thursday, 19 August 2010 5:30 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Problem with CASE.
>
> I take a pic, if it helps...
>
> http://img833.imageshack.us/img833/1456/errorsd.png
>
> Bye.
>
>
> From: Philippe Makowski
> Sent: Wednesday, August 18, 2010 4:11 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Problem with CASE.
>
>
>
> 2010/8/18 João Luiz <jll.listas@...>
> > I'm using Firebird 2.1.3.
>
> So you certainly made a typo somewhere
>
> $ isql localhost:employee -user SYSDBA -password masterkey
> Database: localhost:employee, User: SYSDBA
> SQL> show version;
> ISQL Version: UI-V2.1.3.18185 Firebird 2.1
> Server version:
> Firebird/Darwin/Intel64 (access method), version "UI-V2.1.3.18185
> Firebird 2.1"
> Firebird/Darwin/Intel64 (remote server), version "UI-V2.1.3.18185
> Firebird 2.1/tcp (callandor.local)/P11"
> Firebird/Darwin/Intel64 (remote interface), version "UI-V2.1.3.18185
> Firebird 2.1/tcp (callandor.local)/P11"
> on disk structure version 11.1
> SQL> SELECT EMP_NO, case EMP_NO when 11 then 'oi' end as caso
> CON> FROM EMPLOYEE;
>
> EMP_NO CASO
> ======= ======
> 2 <null>
> 4 <null>
> 5 <null>
> 8 <null>
> 9 <null>
> 11 oi
> 12 <null>
> 14 <null>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]