Create Trigger truURes
On URes
for Update
As
if Update(FResNo)
begin
--申购
Update UApplyShopTable Set FResNo=i.FResNo From UApplyShopTable br,inserted i
Where br.FResNo=i.FResNo ;
--来料
Update UIncomingTable Set FResNo=i.FResNo From UIncomingTable br,inserted i
Where br.FResNo=i.FResNo ;
--领料
Update UOutStorageTable Set FResNo=i.FResNo From UOutStorageTable br,inserted i
Where br.FResNo=i.FResNo ;
--采购
Update UStockOrderTable Set FResNo=i.FResNo From UStockOrderTable br,inserted i
Where br.FResNo=i.FResNo ;
--退货
Update URejectTable Set FResNo=i.FResNo From URejectTable br,inserted i
Where br.FResNo=i.FResNo ;
--报损
Update UReportTable Set FResNo=i.FResNo From UReportTable br,inserted i
Where br.FResNo=i.FResNo ;
--流水账
Update UstockBook Set FResNo=i.FResNo From UstockBook br,inserted i
Where br.FResNo=i.FResNo ;
--欠数
Update ULessBook Set FResNo=i.FResNo From ULessBook br,inserted i
Where br.FResNo=i.FResNo ;
--询价
Update UEnquiryTable Set FResNo=i.FResNo From UEnquiryTable br,inserted i
Where br.FResNo=i.FResNo ;
end 为什么表UApplyShopTable没有触发更改
Where br.FResNo=i.FResNo ;UEnquiryTable中不存在相关fresno ,即:br.FResNo=i.FResNo
你的FResNo被修改,你连接修改后的当然连接不上Create Trigger truURes
On URes
for Update
As
if Update(FResNo)
begin
--申购
Update UApplyShopTable Set FResNo=i.FResNo From UApplyShopTable br,inserted i,deleted d
Where br.FResNo=d.FResNo
and d.URes主键字段 = i.URes主键字段 ; --来料
-- 其他自己类似修改
end
go