Edson Carlos Ericksson Richter wrote: > > 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 >
As problem tracking system tells us (no 1126007 / 1126006) this is a known bug solved with version 7.3.00.47 / 7.4.03.32, both not released so far and no timeschedule available so far for these releases. Sorry for any inconvenieces and thank you for reporting Elke SAP Labs Berlin > > --- > 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] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
