Hello, I`m try to use this code for my After Delete trigger:
deletefrom MOVIMENTOwhere (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"