Still with problems using INSERT trigger

[Edson Carlos Ericksson Richter]

I'm feeling the foolish one in the world. Can you explain me why in name of
god this trigger always set ST_SITUACAO = 'X'???

DROP TRIGGER TRG_CONH_OCORR_INS OF TB_CONHECIMENTO_OCORRENCIAS
//
CREATE TRIGGER TRG_CO_INS
FOR TB_CO
AFTER INSERT EXECUTE (

UPDATE MGR.TB_C
SET ST_SITUACAO = CASE
                                         WHEN :NEW.CO_TIPO_EVENTO=1
                                           THEN 'X'
                                        WHEN :NEW.CO_TIPO_EVENTO=2
                                          THEN 'N'
                                        WHEN :NEW.CO_TIPO_EVENTO=3
                                          THEN 'C'
                                        ELSE 'T'
                                     END
   WHERE NU_C = :NEW.NU_C;
)

Thanks for any advice,

Edson Richter



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.561 / Virus Database: 353 - Release Date: 13/1/2004


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]