迷你版升专业版的时候出现核算项目报错
金蝶云社区-翟疆
翟疆
0人赞赏了该文章 1,062次浏览 未经作者许可,禁止转载编辑于2017年01月06日 17:57:04
升级失败,原因: 用于插入T_Organization客户数据的SQL语句执行错误: INSERT INTO T_Organization(FShortNumber,FItemID,FNumber,FName,FAddress,FPostalCode,FFax,FPhone,FContact,FTaxNum,Fbank,Faccount,FStatus,FValueAddRate) SELECT T1.FShortNumber,T1.FItemID,T1.FNumber,T1.FName,T2.FAddress,T2.FZip,T2.FFax,T2.FPhone,T2.FContact,T2.FTax,T2.FBank,T2.FBank,1072,17 FROM T_Item T1,AIS_GLCust T2,AIS_GLObj T3 WHERE T1.FShortNumber = T3.FObjID AND T2.FObjID = T3.FObjID AND T1.FItemClassID = 1 AND T1.FDetail=1 AND T3.FClsID = 1 AND T1.FItemID NOT IN (SELECT FItemID FROM T_Organization)