22,297
社区成员




if isnull((select FStatus from inserted ),0)=1 6 and isnull((select FStatus from deleted ),0)=0
或者
DECLARE @FStatus INT --审核状态
DECLARE @FOldStatus int --消审状态
select @FInterID=FInterID,@FStatus=Inserted.FStatus FROM inserted
select @FOldStatus = FStatus from deleted
审核状态为
IF UPDATE(FStatus) AND @FStatus=1 AND @FOldStatus=0
主表这样操作是OK的,
现在碰到明细表操作问题,比如销售订单明细表行关闭时,更新的状态如下
Update SEOrderEntry SET FMrpClosed=1,FMrpAutoClosed=0 Where FInterID=6287 and FEntryID=2
明细表就不能直接写成下面这样了,请问如何修改,谢谢
IF UPDATE(FMrpClosed) and @FMrpClosed=1 and @FMrpAutoClosed=0 AND @FOldMrpClosed=0 and @FOldMrpAutoClosed=1