触发器问题

[sadikaqy]

icmrpresult 计划订单 seorderentry 销售订单 porequestentry 采购申请单

create trigger trrigger_note
on icmrpresult
after insert
as
update a set a.fheadselfj0546=b.fnote
from icmrpresult a
left join seorderentry b 
on a.FOrgSaleInterID=b.FInterID
where a.forgentyrid=b.fentryid

update a set a.fentryselfp0131=b.fheadselfj0546
from porequestentry a
left join icmrpresult b on a.fsourceinterid=b.FOrgSaleInterID
where a.fentryid=b.forgentyrid

第二个update不会直接触发，而是第二次新增时触发，不知道是什么原因？

[sadikaqy]

我想新增计划订单时更新计划订单的字段等于销售订单的字段
新增采购申请单时更新采购申请单的字段等于计划订单的字段
请问要怎么实现？

[sadikaqy]

create trigger trrigger_note
on porequestentry 
after insert
as
update a set a.fentryselfp0131=b.fheadselfj0546
from porequestentry a
left join icmrpresult b on a.fsourceinterid=b.FOrgSaleInterID
where a.fentryid=b.forgentyrid

为什么采购申请单第一次新增时不更新，新增下一条上一条才更新？

[xuam]

create trigger trrigger_note
on icmrpresult
after insert
as
begain
update a set a.fheadselfj0546=b.fnote
from icmrpresult a
left join seorderentry b 
on a.FOrgSaleInterID=b.FInterID
where a.forgentyrid=b.fentryid

update a set a.fentryselfp0131=b.fheadselfj0546
from porequestentry a
left join icmrpresult b on a.fsourceinterid=b.FOrgSaleInterID
where a.fentryid=b.forgentyrid
end

[CSDNDoc]

insert触发器当然只有新增时触发了

[CSDNDoc]

这么写触发器是有问题的，扩大了修改范围（或者说修改范围不受控制），容易有性能问题