> 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

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


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

Kadee