|
From: agostinho <ago...@cl...> - 2002-09-08 08:40:31
|
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...
|