|
6#
楼主 |
发表于 2002-6-21 22:48:00
|
只看该作者
老朱同志看看我寫的觸發器。在一個觸發器中完成了余貨回倉的功能。
CREATE trigger utr_wh_more_update on trade_wh_more after update as
if (columns_updated()&2) >0
--如果表trade_wh_more的第二列發生更新則執行以下程式
begin
declare @wh_ins_line_no as int,@request_line_pt_sum as decimal(8,2),@wh_more_pt_sum as decimal(8,2),@wh_ins_line_pt_bak as decimal(8,2),@wh_ins_line_pt_new as decimal(8,2)
select @wh_ins_line_no = (select wh_ins_line_no from trade_request_line inner join inserted on trade_request_line.request_line_no = inserted.request_line_no)
select @request_line_pt_sum =(select request_line_pt_sum from uv_qry_sum_request_line_pt where wh_ins_line_no = @wh_ins_line_no)
select @wh_more_pt_sum = (select wh_more_pt_sum from uv_qry_sum_wh_more_pt where wh_ins_line_no = @wh_ins_line_no)
select @wh_ins_line_pt_bak = (select wh_ins_line_pt from trade_wh_ins_line_pt where wh_ins_line_no = @wh_ins_line_no)
select @wh_ins_line_pt_new = (@wh_ins_line_pt_bak - @request_line_pt_sum + @wh_more_pt_sum)
update trade_wh_ins_line set wh_ins_line_pt = @wh_ins_line_pt_new where wh_ins_line_no = @wh_ins_line_no
end
---------------------------------------------------------------------------------
|
|