Hello, I`m try to use this code for my After Delete trigger:
delete
from MOVIMENTO
where (IDEMPRESA = OLD.idempresa) and
(upper(TABELA) = 'NFENTRADA_ITEM') and
(CODIGO = OLD.idempresa_item);
But, when execute. show me error.. that`s says
"old is not initialize" (sorry,but I dont know how exactly error msy
because in my SO, give in portuguese)..
my question is: how can I use OLd and NEW in posgre?
Best Regards,
T.·.F.·.A.·. S+F
*Fellipe Henrique P. Soares*
*"Life is a game without Tutorial"*
*http://fellipeh.eti.br*