想做一个 订单和生产单的加工的 配比
如果保存订单的SKU 在 生产单中没有找到该SKU 前端则返回错误信息
触发器
USE [UFTData702166_100005]
GO
/****** Object: Trigger [dbo].[Sale_check_up] Script Date: 11/12/2021 08:54:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER trigger [dbo].[Sale_check_up]
on [dbo].[SA_SaleOrder_b]
for update ,insert-
AS
begin
declare @errInfo Varchar(1000)
Declare @idinventory int
select @idinventory
exec SPUDF_ProcessA @idinventory
end
存储过程
USE [UFTData702166_100005]
GO
/****** Object: StoredProcedure [dbo].[SPUDF_ProcessA] Script Date: 11/12/2021 09:34:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[SPUDF_ProcessA]
@errInfo Varchar(1000) output
AS
Declare @quantity decimal
Declare @idinventory int
IF exists (select idinventory ,sum(quantity) as quantity1
from (
select idinventory, quantity from [UFTData702166_100005].[dbo].[MP_IntendSaleOrder_b]
union all
select idinventory, - quantity from [UFTData702166_100005].[dbo].[SA_SaleOrder_b]
) x
group by idinventory having count(*) > 0 and idinventory=@idinventory)
begin
set @errInfo = @idinventory + @quantity + '超预测单量'
return
end
Set @errInfo='000'
Return
一直不被执行，帮忙看看哪里错了。
你应该在改和增加上添加触发器。
那就应该从改和增加上入手。