At 06:37 AM 15/12/2003 +0000, you wrote:

> > things happening "sometimes" is not something we could tolerate. It
>must be
> > something in your trigger - like not testing for NULL or something.
>How
> > 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
>AS
>begin

if (new.shipqty is not null and new.io is not null) then
begin

> UPDATE jsaorderd
> SET JSAORDERD.shipqty = JSAORDERD.shipqty+ NEW.shipqty *new.io ,
> JSAORDERD.ORDfn = new.shipfn
> WHERE JSAORDERD.ORDERNO = NEW.ORDERNO
> AND JSAORDERD.ordsno = NEW.ordsno;

end

>end
>
>
>and I can sure there isnot null value in
> jsaorderd.shipqty

/heLen