|Subject||Re: [firebird-support] Re: Trigger unstable on WINNT ?|
At 06:37 AM 15/12/2003 +0000, you wrote:
> > things happening "sometimes" is not something we could tolerate. Itif (new.shipqty is not null and new.io is not null) then
> > something in your trigger - like not testing for NULL or something.
> > about showing us the content of your trigger.
> > Alan
>Thanks a lot for your quickly reply.
>My trigger as follow:
>CREATE TRIGGER JPKSHIPD_AI0 FOR JPKSHIPD
>ACTIVE AFTER INSERT POSITION 0
> UPDATE jsaorderdend
> SET JSAORDERD.shipqty = JSAORDERD.shipqty+ NEW.shipqty *new.io ,
> JSAORDERD.ORDfn = new.shipfn
> WHERE JSAORDERD.ORDERNO = NEW.ORDERNO
> AND JSAORDERD.ordsno = NEW.ordsno;
>and I can sure there isnot null value in