T3升级到U890,升级成功后,进入卡片管理,双击任意一张卡片,均报错:运行时错误20007 Invalid cellreference
经过跟踪发现在执行到以下语句报错:
经过跟演示账套对比,发现在出问题的账套执行结果是35行,而演示账套的直接结果为34行,经过分析发现,有记录在fa_items表中不存在,使用如下语句删除这些记录后正常。Select * from fa_ItemsOfModel where sModelID = N'1' and iSheetID = 0
delete from fa_ItemsOfModel
where sModelID = '1' and iSheetID = 0 and sitemID in
(
select sitemID from fa_ItemsOfModel where sModelID = '1' and iSheetID = 0 and sitemid not in(Select sid from fa_items)
)