22,207
社区成员
发帖
与我相关
我的任务
分享
ALTER TRIGGER test22
ON [dbo].[ICStockBill]
AFTER INSERT
AS
SET NOCOUNT ON;
IF NOT UPDATE(fstatus)
RETURN;
UPDATE a
SET A.FHeadSelfY0237 = B.FBillNo
FROM PPBOM a,
ICStockBillEntry c,
INSERTED b
WHERE c.FInterID = b.FInterID
AND a.FHeadSelfY0236 = c.FICMOBillNo
AND FTranType=24;
ALTER TRIGGER test22
ON [dbo].[ICStockBill]
AFTER INSERT
AS
SET NOCOUNT ON;
DECLARE @FTranType SMALLINT;
SELECT @FTranType = FTranType
FROM INSERTED;
IF NOT UPDATE(fstatus)
RETURN;
IF (@FTranType = 24)
BEGIN
UPDATE a
SET A.FHeadSelfY0237 = B.FBillNo
FROM PPBOM a,
ICStockBillEntry c,
INSERTED b
WHERE c.FInterID = b.FInterID
AND a.FHeadSelfY0236 = c.FICMOBillNo;
END;