查询下表发现同商品ID有两条记录:
select * from PType_Price where PTypeID not in(select typeid from ptype)
select * from PType_STypePrice where PTypeID not in(select typeid from ptype)
select * from PType_Units_Ext where PTypeID not in(select typeid from ptype)
select * from QP_PType_Ext where PTypeID not in(select typeid from ptype)
数据库删除商品档案后,再手动删除下表关联信息
delete from PType_Price where PTypeID not in(select typeid from ptype)
delete from PType_STypePrice where PTypeID not in(select typeid from ptype)
delete from PType_Units_Ext where PTypeID not in(select typeid from ptype)
delete from QP_PType_Ext where PTypeID not in(select typeid from ptype)
管家婆ERP V3从9.0升级到V3II TOP9.72的步骤
1、先备份数据库,ERP V3 9.0 升级到ERP V3 TOP 9.0,运行9.4升级包,升级到ERP V3 TOP 9.4(不升级主程序,只升级数据库。)
3、运行9.72升级包,升级到ERP V3 TOP 9.72(不升级主程序,只升级数据库。)
4、删除ERP V3程序
5、安装ERP V3 TOP 9.72安装包(测试联接原来的数据库)
6、备份9.72数据库,打补丁。