> I know nothing about Firebird 2.0, but the below statement does

refer to

> 'a1' (ai.id) which is a non-existing table.
>
> HTH,
> Set

Sorry (it's not A1, but S1) mea culpa.
SURE all tables exists, and all type are correct.
The problem is due to a new restriction in FB 2.0 (work fine in FB
1.5) Anyone use computed fields implicating other tables, and with
similar errors? any solution about this?

> > /**********************************/
> >
> > 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 s1.id = s2.id)
> > ,0)
> > as numeric(14,2)));
> >
> > /**********************************/