触发器用法,删除领料单中数量为0的记录

renzhong

CREATE TRIGGER [MOCTE01] ON [dbo].[MOCTE]
FOR INSERT, UPDATE
DELETE MOCTE
FROM MOCTE LEFT JOIN INSERTED ON MOCTE.TE004=INSERTED.TE004 AND MOCTE.TE001=INSERTED.TE001 AND MOCTE.TE002=INSERTED.TE002
WHERE MOCTE.TE004=INSERTED.TE004 AND MOCTE.TE001=INSERTED.TE001 AND MOCTE.TE002=INSERTED.TE002 AND MOCTE.TE005='0'

这样写了以后,出现record changed by another user的提示,经过测试以后,发现只要领料记录中有不等于0的记录就会出现这个提示,请各位给点建议

看看问题出在哪里

renzhong

问题补充:
CREATE TRIGGER [MOCTE01] ON [dbo].[MOCTE]
FOR INSERT, UPDATE
AS
BEGIN
DELETE MOCTE
FROM MOCTE LEFT JOIN INSERTED ON MOCTE.TE004=INSERTED.TE004 AND MOCTE.TE001=INSERTED.TE001 AND MOCTE.TE002=INSERTED.TE002
WHERE MOCTE.TE004=INSERTED.TE004 AND MOCTE.TE001=INSERTED.TE001 AND MOCTE.TE002=INSERTED.TE002 AND MOCTE.TE005=0
END