問題現(xiàn)象：

銷售模塊，查詢銷售統(tǒng)計(jì)表時(shí)報(bào)錯(cuò)：操作數(shù)數(shù)據(jù)類型varchar對于sum運(yùn)算符無效。錯(cuò)誤位于模塊：newclsReportDataSaleTotal.MoveSaleGroup()。數(shù)據(jù)庫中數(shù)據(jù)表rpt_flddef,rpt_fltdef,rpt_glbdef,rpt_grpdef,rpt_reldef,rpt_folder,rpt_itmdef異常，數(shù)據(jù)錯(cuò)亂。

解決方案：

請做好帳套備份，刪除該年度帳中rpt開頭的7張表，從演示帳套或正常帳套中把這7張表導(dǎo)過去。導(dǎo)入請?jiān)谫~套庫下執(zhí)行：

drop table rpt_flddef,rpt_fltdef,rpt_glbdef,rpt_grpdef,rpt_reldef,rpt_folder,rpt_itmdef

select * into rpt_flddef from UFDATA_999_2011..rpt_flddef

select * into rpt_fltdef from UFDATA_999_2011..rpt_fltdef

select * into rpt_glbdef from UFDATA_999_2011..rpt_glbdef

select * into rpt_grpdef from UFDATA_999_2011..rpt_grpdef

select * into rpt_reldef from UFDATA_999_2011..rpt_reldef

select * into rpt_folder from UFDATA_999_2011..rpt_folder

select * into rpt_itmdef from UFDATA_999_2011..rpt_itmdef

UFDATA_999_2011為999演示賬套。