[Firebird-test] Bug in FB 1.0?

[news.clix.pt <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 = it dosen't work

Is it a bug?
I'm using firebird 1.0

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



Best regards

Agostinho

ago...@cl...