U8 材料出库单 表体添加自定义项,编写触发器!
材料出库单----数量>现存量+计划生产数(扩展自定义项,手工填写数量) 时,提示保存失败。触发器 这样写 不对,求解。
createTrigger Tri_RdRecord11_Order
ONRdrecords11 for insert,update
AS
Begin
set nocount on
declare @RiQ as decimal(20)
declare @CiQ as decimal(20)
declare @RCF1 as decimal(20)
SELECT @RiQ=rdrecords11.iQuantity from rdrecords11
SELECT @CiQ=CurrentStock.iQuantity FROM CurrentStock RIGHT JOIN rdrecords11 ON rdrecords11.cInvCode=CurrentStock.cInvCode
SELECT @RCF1=rdrecords11_extradefine.cbdefine1 FROM rdrecords11_extradefine RIGHT JOIN rdrecords11 ON rdrecords11.AutoID=rdrecords11_extradefine.AutoID
IF @RiQ>@CiQ+@RCF1
raiserror('出库数大于库存数+计划生存数之和,单据不允许保存!!!',16,1)
END 可以联系我QQ 10408080
页:
[1]