|
发表于 2016-2-27 17:46:02
|
显示全部楼层
1,在问题年度执行以下脚本,下列脚本中有UFDATA_999_2011,若没有这个账套可以参照其其他账套: --1.采用降级再升级的方法,将版本标志降低为10.0的版本标志8.216,执行以下语句即可: update accinformation set cvalue='8.216' where csysid='AA' and cid='99' --2.执行以下语句: 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 alter table RPT_FldDEF drop column CurGroupCol,CurSubTotalCol 2,进入系统管理,重新进行SQL数据,升级成功再建立年度账。 |
|