Thank you for your interest. I don't have enough experience about Firebird SQL. My graduation project was about a law office program. I didn't have any problem during the presentation. Now I have to deal with that program again but it gives an error about CASE WHEN statement.

Tables' names are in Turkish, so I think its better to write the table names first, in order to help you to understand.

Table Name: Fields:

HESAPLAR HESAP_ID
HESAP_TARIHI
HESAP_SEC_TABLO
HESAP_SEC_TAB_ID
PERSONEL_KART PER_ID
PER_ISIM
PER_SADI
MUSTERI_KARTI MUS_ID
MUS_ISIM
MUR_SADI


And this is the code that gives error at CASE WHEN statement:


select DISTINCT HESAPLAR.HESAP_ID,
HESAPLAR.HESAP_TARIHI,HESAPLAR.hesap_sec_tablo,
HESAPLAR.HESAP_SEC_TAB_ID,
CASE when hesaplar.hesap_sec_tablo = 0
then (select trim(PERSONEL_KART.PER_ISIM) ||' '||trim(PERSONEL_KART.PER_SADI)
from personel_kart
where personel_kart.per_id=hesaplar.hesap_sec_tab_id)
else (select trim(MUSTERI_KARTI.MUS_ISIM) ||' '||trim(MUSTERI_KARTI.MUS_SADI)
from musteri_karti
where musteri_karti.mus_id =hesaplar.hesap_sec_tab_id)
end as kisi,hesaplar.hesap_aciklama,hesaplar.hesap_dekonttur,
HESAPLAR.HESAP_TUR_ID,hesaplar.hesap_debit,hesaplar.hesap_credit
case when hesaplar.hesap_sec_tablo = 0 then ''P'' Else ''M'' end as ST
from hesaplar

As I said before, I don't have enough experience about Firebird SQL and I will be appreciate for your help.

Thank you.






----- Original Message ----
From: Martijn Tonies <m.tonies@...>
To: firebird-support@yahoogroups.com
Sent: Thursday, November 23, 2006 5:55:47 PM
Subject: Re: [firebird-support] Hi!

> Im a recruit in this group, I ve found this group while searching for

documentation about firebird SQL.

>
> I use firebird 1.5 and EMS Interbase/Firebird Manager 3. When I try to

write a SQL code on SQL editor, it gives me an error.

>
> Im not sure if its ok to send questions to this group for help. But if it

is, I would like to ask some questions, I appreciate your interest, thank
you.

>

This is "firebird-support" , so yes, that's OK.

Make sure to use a subject that's useful and provide all details needed to
answer your question.

Welcome to the group :)

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene. com
My thoughts:
http://blog. upscene.com/ martijn/
Database development questions? Check the forum!
http://www.database developmentforum .com






____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited

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