create trigger t1 on feedin for delete
as
update material set 库存 = 库存 - feedinme.入库数量 from feedinme, deleted
where feedinme.据编号 = deleted.据编号
and material.物料编号 = feedinme.物料编号
delete feedinme from deleted where 单据编号 = deleted.单据编号
go愉快的登山者 ⊙
◢◣◢◣◢◣
as
update material set 库存 = 库存 - feedinme.入库数量 from feedinme, deleted
where feedinme.据编号 = deleted.据编号
and material.物料编号 = feedinme.物料编号
delete feedinme from deleted where 单据编号 = deleted.单据编号
go愉快的登山者 ⊙
◢◣◢◣◢◣
as
delete feedin where receipt =select receipt from deleted
update material set quantity=quantity-(select quantity from deleted)
where idno=(select goodsid from deleted)
from deleted 这 deleted 是哪来的呀
SELECT *
FROM deleted
CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
AS
update material set quantity = quantity - feedinme.quantity from feedinme, deleted
where feedinme.receipt = deleted.receipt
and material.idno = feedinme.receipt
delete feedinme from deleted where receipt = deleted.receipt
go
lifeforu(苍白到底)也报错!
FOR DELETE
AS
update material set quantity = quantity - feedinme.quantity from feedinme, deleted
where feedinme.receipt = deleted.receipt
and material.idno = feedinme.receipt
delete feedinme from deleted where receipt = deleted.receipt
报错列名quantity 不正确,
列名receipt 不正确,
到底应该怎么写呀!
INSTEAD OF delete
AS
BEGIN
update material set quantity=material.quantity-tem.quantity from (select goodsid,sum(quantity) quantity from feedinme where receipt in (select receipt from deleted) group by goodsid) tem where material.idno=tem.goodsid
delete feedinme where receipt in (select receipt from feedinme)
delete feedin where receipt in (select receipt from feedinme)
END
INSTEAD OF delete
.....
我执行删除一条feedin后,把所有的feedinme都删除了
這句錯了大力幫你解決了我也來晚了
如果把
delete feedinme from deleted where receipt = deleted.receipt
换上去,检查语法都通不过,报错!
5555.............
应该是把上句写成
delete feedinme from deleted where feedinme.receipt <> deleted.receipt
应该写成
delete feedinme from deleted where feedinme.receipt <> deleted.receipt谢谢 tj_dns(愉快的登山者), lifeforu(苍白到底),zarge(鲨至),zjcxc(邹建) ,大力.zhouzhouzhou(人生程序),happy_0325(快乐)(按出场顺序排名:-)).
可是我觉得应该还可以用其它方法的....
这句不对delete feedinme from deleted where feedinme.receipt = deleted.receipt
会把所有的记录删除...