U872取存货编码触发器
USEGO
/****** Object:Trigger . Script Date: 04/24/2012 20:47:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create TRIGGER . ON .
FOR INSERT,UPDATE
AS
BEGIN
UPDATE a
SET a.cInvCode = b.cInvCode
FROM fin_invprice a
right JOIN Inventory b
on a.cinvcode=b.cinvcode
and b.cInvCCode like '12%'
and b.cInvDefine6 = '外协'
and a.cinvcode not in (b.cinvcode)
END
--U872取存货编码触发器,有价格数据库表:fin_invprice,存货档案表:Inventory--当存货档案满足条件 存货大类编码cInvCCode开头时12, 采购方式cInvCCode是外协,且价格数据库中没有编码时--现在存货档案保存时提示有另个用户在操作--请高手指点
都过了好多年了,不知道解决了没:) 好东西要收走!
页:
[1]