(FAQ)采购申请单，选择物料后报错
原因分析：一个物料后台多计量单位表中保存了多个基本计量单位。 解决方法：提供下面修复脚本。 --备份多计量单位 select * into bak0529_multimeasureunit from t_bd_multimeasureunit; --根据物料基础页签基本计量单位更新多计量单位表错误标记的基本计量单位 update t_bd_multimeasureunit set fisbasicunit=0 where fisbasicunit=1 and not exists (select * from t_bd_material where fid = t_bd_multimeasureunit.fmaterialid and fbaseunit = t_bd_multimeasureunit.fmeasureunitid); --删除重复的多计量单位 delete t_bd_multimeasureunit where fid not in (select max(fid) from t_bd_multimeasureunit group by fmaterialid,fmeasureunitid);