一個更新的觸發，大家幫我。

[vfork]

table A,table B

B的flag初始為0，
當flag更新為1時，A.Amount=A.Amount+B.Amount
當flag更新為0時，A.Amount=A.Amount-B.Amount

我寫的錯誤的觸發如下：
CREATE TRIGGER In_update_store ON [dbo].B
FOR UPDATE
AS
if update(flag)
begin
update A set A.amount=A.amount-A.Bmount from inserted B where A.id=B.Mtid and B.flag=0
update A set A.amount=A.amount+B.Amount from inserted B where A.id=B.Mtid and B.flag=1
end

[$扫地僧$]

create table A
(
id int,
Amount int
)

create table B
(
mid int,
flag int,
Amount int
)

insert A select 1,0
insert B select 1,0,10


CREATE TRIGGER In_update_store ON [dbo].B
FOR UPDATE
AS
if update(flag)
begin
update A set A.amount=A.amount-B.amount from inserted B where A.id=B.Mid and B.flag=0
update A set A.amount=A.amount+B.Amount from inserted B where A.id=B.Mid and B.flag=1
end


update B set flag=1 from B where Mid=1

select * from A
select * from B

[vfork]

樓上的再干什麼？

[huailairen]

update A set A.amount=A.amount-A.Bmount from inserted B where A.id=B.Mtid and B.flag=0 中-----------》A.amount-A.Bmount 是不是写错了啊
应该是A.Amount-B.Amount 吧

[vfork]

不是，flag=1觸發結果正常，但是在delphi裡報錯，（刪除觸發就在delphi中不報錯了）
flag=0時候，結果不正常，而且也報錯。