[Firebird-test] Bug in FB1.0?

[agostinho <ago...@cl...>]

Hi

I have the following problem
I have this code bellow  in a SP inside a for select and it only work =
wih
the IN clause.
If i chenge to =3D it dosen't work

Is it a bug?
I'm using firebird 1.0

         UPDATE inventario SET CUSTOMEDIO =3D (
              SELECT PRECOMEDIO FROM CUSTEIO
                WHERE custeioid IN (SELECT MAX(CUSTEIOID)
                                   FROM CUSTEIO WHERE (codart=3D:CODART) =
AND
(tipo=3D0) and (data <=3D:DATAF)))
              WHERE (CODART=3D:CODART) AND (CODARM=3D:CODARM) AND (util =
=3D user);



Best regards

Agostinho

ago...@cl...