| Subject | Re: [Firebird-general] expression evaluation not supported (FIREBIRD 2.0 RC3) |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2006-07-12T08:03:32Z |
"skander_sp" <skander_sp@...> wrote:
of them is a string.
Dmitry
>What are the datatypes of "cantidad", "precio" and "dto"? It looks like any
> Creating a computed field (that work fine in 1.5.3) give an error in 2.0
>
> ALTER TABLE S1 ADD BASE COMPUTED BY (
> cast(
> coalesce(
> (select sum(cast(s2.cantidad*s2.Precio as numeric(14,4))
> *cast((1.0-s2.dto/100)*(1.0-s1.dto/100) as numeric(6,5)))
> from s2
> where a1.id = s2.id)
> ,0)
> as numeric(14,2)));
of them is a string.
Dmitry