|
发表于 2016-10-4 20:58:57
|
显示全部楼层
您可以新建账套,然后参照以下脚本执行重写账表格式:use UFDATA_***_**** --将星号分别替换成问题账套号和问题年度号
delete from Rpt_FldDEF
go
delete from Rpt_FltDEF
go
delete from Rpt_GlbDEF
go
SET IDENTITY_INSERT Rpt_FldDEF ON
insert into Rpt_FldDEF(ID_Field,ID,Name,Expression,Condition,ModeEx,OrderEx,TopEx,LeftEx,Width,Height,Visible,Note,nameForeign,iColSize,FormatEx,iAlignStyle,iSize)
select * from UFDATA_***_****..Rpt_FldDEF --将星号分别替换成新建的演示账套号和演示账套年度号
SET IDENTITY_INSERT Rpt_FldDEF OFF
go
SET IDENTITY_INSERT Rpt_FltDEF ON
insert into Rpt_FltDEF(ID_Flt,Location,ID,Name,Note,Expression,ModeEx,IsSingle,Flag,Caption,iLeft,iTop,iWidth,iHeight,iCaptionLeft,iCaptionWidth,iPage,iRefSelect)
select * from UFDATA_***_****..Rpt_FltDEF --将星号分别替换成新建的演示账套号和演示账套年度号
SET IDENTITY_INSERT Rpt_FltDEF OFF
go
SET IDENTITY_INSERT Rpt_GlbDEF ON
insert into Rpt_GlbDEF(ID,SystemID,Name,Title,DatabaseEx,WhereEx,Predicate,Type,Relation,Note,Cols,Section,Fields,DataSource,BaseTable,IsBaseTable,IsControlCreate,IsBase,GroupDefine)
select * from UFDATA_***_****..Rpt_GlbDEF --将星号分别替换成新建的演示账套号和演示账套年度号
SET IDENTITY_INSERT Rpt_GlbDEF OFF
go
|
|