Subject | Re: [firebird-support] Re: CASE and SQL |
---|---|
Author | Ivan Prenosil |
Post date | 2005-01-20T13:30:16Z |
> Is it not posible to use a parameter after the WHEN clause ?What exactly do you mean by "doesn't seem to work" ?
> Like this:
>
> Update Table set
> F1 = :PF1,
> F2 = (Case When (F1=0) then
> (:PF1 * F3)
> else
> (:PF1 * (F2 / F1))
> end)
>
>
> The above doesn't seem to work...
Ivan