HELP!这样的触发器该怎么写?
表BASEDOC其中有四个字段
应收amount,已收hasblan,应付payamount,可付canarg
当字段:应收amount,已收hasblan,应付payamount任一字段发生改变时都重新计算:可付canarg
触发器写法如下,可canarg都成0了:
CREATE TRIGGER upd_basedoc ON basedoc
for UPDATE
AS
if update(hasblan) or update(payamount) or update(amount)
begin
declare @ivcno char(11)
declare @hasblan numeric(18,3)
declare @payamount numeric(18,3)
declare @amount numeric(18,3)
select @ivcno=invoiceno,@hasblan =hasblan,@payamount=payamount,@amount=amount from inserted
update basedoc set canarg=
case isnull(@payamount,0)
when 0 then 8.625*isnull(@hasblan,0)
else
case isnull(@amount,0)
when 0 then 0
else @payamount*@hasblan/@amount
end
end
where invoiceno=@ivcno
end
该如何修改呢?