application.
This is the expected behavior.
Best Regards,
Thomas
-Original Message-
From: Florian Schmitz [mailto:[EMAIL PROTECTED]
Sent: Dienstag, 14. Februar 2006 10:38
To: Anhaus, Thomas
Subject: Re: Problem creating Trigger
Hello Thomas,
see the attached trace.
Trigger-Defi
Hello list,
i'm quite amused by my own stupidity while trying to create the following
trigger :
CREATE TRIGGER ECOUPON_UPDATE FOR ECOUPON AFTER UPDATE EXECUTE (
TRY
IF NEW.INVOICE_UUID IS NOT NULL AND NEW.CREDIT_UUID IS NOT NULL THEN BEGIN
DELETE FROM SCHEMA1.AGG_INVOICE WHERE UUID = :OLD.
Edson Carlos Ericksson Richter wrote :
>
>I've found an old mail saying that OLD and NEW works only in UPDTE
>triggers. So, should I not use OLD in DELETE trigger too?
>
>Thanks,
>
>Richter
>
>
>Edson Carlos Ericksson Richter escreveu:
>
>> Thank you, you is right. I forgot the brackets...
>> But
maxdb@lists.mysql.com
cc Edson
Carlos
Ericksson Richter Subject
ists.mysql.com
Objet : Problem creating trigger
I'm creating a very simple trigger:
create trigger TRG_PARCELA_DEL for TB_PARCELA after delete
execute
if old.CO_SITUACAO <> 2 then
UPDATE MGR.TB_CC_ORCAMENTO
SET VL_PROVISIONADO = VL_PROVISIONADO - :old.VL_NOMINAL_REAIS,
VL_PAGO
Ericksson Richter Subject
Problem creating trigger
09.06.2005 09:31
Carlos
Ericksson Richter Subject
Problem creating trigger
09.06.2005 09:31 Classifi
e : Edson Carlos Ericksson Richter
> [mailto:[EMAIL PROTECTED]
> Envoyé : jeudi 9 juin 2005 14:31
> À : maxdb@lists.mysql.com
> Objet : Problem creating trigger
>
>
> I'm creating a very simple trigger:
>
> create trigger TRG_PARCELA_DEL for TB_PARCELA after de
I'm creating a very simple trigger:
create trigger TRG_PARCELA_DEL for TB_PARCELA after delete
execute
if old.CO_SITUACAO <> 2 then
UPDATE MGR.TB_CC_ORCAMENTO
SET VL_PROVISIONADO = VL_PROVISIONADO - :old.VL_NOMINAL_REAIS,
VL_PAGO = VL_PAGO - :old.VL_PAGO
WHERE EXISTS (SELECT *
