版本:  PS8.5PACK3    数据库:  SQL2000

操作系统:   win2000pro   模块:进销存 

*问题描述:

客户有两套帐cwbase5，cwbase6，想实现两套帐中的物料字典一致

*解决方案：

分别在两套帐上lswlzd表上建触发器，在cwbase5上建触发器如下：

create trigger TR_LSWLZD_insert

on LSWLZD

after insert

as

begin

     insert into cwbase6.lc0069999.LSWLZD

     select * from inserted

end

create trigger TR_LSWLZD_delete

on LSWLZD

after delete

as

begin

      delete from cwbase6.lc0069999.LSWLZD

   where LSWLZD_WLBH in (select LSWLZD_WLBH from deleted)

end

create trigger TR_LSWLZD_UPDATE

on LSWLZD

after update

as

begin

     delete from cwbase6.lc0069999.LSWLZD

     where LSWLZD_WLBH in (select LSWLZD_WLBH from deleted)

     insert into cwbase6.lc0069999.LSWLZD

     select * from inserted

end