U8 材料出库单 表体添加自定义项，编写触发器！

唱⒈首歌

材料出库单----数量>现存量+计划生产数（扩展自定义项，手工填写数量） 时，提示保存失败。
触发器 这样写 不对，求解。
createTrigger Tri_RdRecord11_Order
ON  Rdrecords11 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

gly2k8

可以联系我QQ 10408080