Subject | Re: [firebird-support] CASE WHEN error |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2006-11-25T12:56:47Z |
Esra Ozdemir wrote:
hesaplar.hesap_credit as case
and then Firebird doesn't know what to do with WHEN where it expects a
comma.
If you changed to
hesaplar.hesap_credit,
case when hesaplar.hesap_sec_tablo = 0 then ''P'' Else ''M'' end as ST
it should either succeed or give you another error message.
HTH,
Set
> "Invalid token.Dynamic SQL Error.That would be the missing comma. I.e.
> SQL error code = -104.
> Token unknown - line 20, char 4.
> when."
>hesaplar.hesap_creditis interpreted as
>case when hesaplar.hesap_sec_tablo = 0 then ''P'' Else ''M'' end as ST
hesaplar.hesap_credit as case
and then Firebird doesn't know what to do with WHEN where it expects a
comma.
If you changed to
hesaplar.hesap_credit,
case when hesaplar.hesap_sec_tablo = 0 then ''P'' Else ''M'' end as ST
it should either succeed or give you another error message.
HTH,
Set