<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#333333">
Hi,<br>
<br>
You're using a trigger AFTER, in your case could be BEFORE?<br>
Cause when you use AFTER the var OLD not exists...<br>
I don't know if I understand exactly what you'll do to ativate this
trigger..<br>
but I think maybe is it..<br>
<br>
try..<br>
<br>
<br>
Em 31/08/2012 14:10, Fellipe Henrique escreveu:
<blockquote
cite="mid:CAF1jwZH+cXLCwHwZCF53eBtXADm=u4B_+6kQqJA9GfmctJ=Zaw(at)mail(dot)gmail(dot)com"
type="cite">Hello, I`m try to use this code for my After Delete
trigger:
<div><br>
</div>
<div>
<div> delete</div>
<div> from MOVIMENTO</div>
<div> where (IDEMPRESA = OLD.idempresa) and</div>
<div> (upper(TABELA) = 'NFENTRADA_ITEM') and</div>
<div> (CODIGO = OLD.idempresa_item);</div>
<div><br>
</div>
<div>But, when execute. show me error.. that`s says</div>
<div><br>
</div>
<div>"old is not initialize" (sorry,but I dont know how exactly
error msy because in my SO, give in portuguese)..</div>
<div><br>
</div>
<div>my question is: how can I use OLd and NEW in posgre?</div>
<div><br>
</div>
<div>Best Regards,</div>
<div><br>
</div>
<div><br>
</div>
<span style="color:black">T.·.F</span><span style="color:black">.·.A</span><span
style="color:black">.·.</span> S+F<br>
<p style="height:17px;width:273px"><b><span style="color:black">Fellipe
Henrique P. Soares</span></b><span
style="font-size:7.5pt;color:rgb(102,102,102)" lang="EN-US"><br>
</span></p>
<p style="height:17px;width:273px"><b><span style="color:black">"Life
is a game without Tutorial"</span></b></p>
<p style="height:17px;width:273px"><font face="garamond, serif"><b><a
moz-do-not-send="true" href="http://fellipeh.eti.br"
target="_blank">http://fellipeh.eti.br</a></b></font></p>
</div>
</blockquote>
<br>
</body>
</html>