--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:

> > Is it not posible to use a parameter after the WHEN clause ?
> > 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...
>
> What exactly do you mean by "doesn't seem to work" ?

In IBExpert it comes up with:

Dynamic SQL Error.
SQL error code = -607.
Array/BLOB/DATE data types not allowed in arithmetic.

>
> Ivan