[Firebird-test] sub select's

[news.clix.pt <ago...@cl...>]

Hi all

Why in a select procedure this don't work

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


and this works fine

            SELECT MAX(CUSTEIOID) FROM CUSTEIO
                   WHERE CUSTEIO.codart=:CODART AND CUSTEIO.tipo=0 and
                   CUSTEIO.data <=:DATAF
                   INTO :ID;

            SELECT PRECOMEDIO
              FROM CUSTEIO
              WHERE custeio.CODART = :CODART AND CUSTEIO.tipo=0
                AND custeio.custeioid=:ID INTO :QTMOV;

            UPDATE inventario SET inventario.CUSTOMEDIO=:QTMOV
            WHERE INVENTARIO.CODART = :CODART AND INVENTARIO.CODARM =
:CODARM AND inventario.util = USER;


is a bug?

thanks

ago...@cl...