调拨单等单据定位功能没有过滤条件

/*调拨单等单据定位功能没有过滤条件
  ufdata_001_2009为有问题账套,ufdata_002_2009为新建账套
*/

TRUNCATE TABLE ufdata_001_2009.dbo.rpt_fltdef
TRUNCATE TABLE ufdata_001_2009.dbo.rpt_flddef
TRUNCATE TABLE ufdata_001_2009.dbo.rpt_glbdef

set IDENTITY_INSERT ufdata_001_2009.dbo.rpt_fltdef  on
INSERT ufdata_001_2009.dbo.rpt_fltdef
([ID_Flt], [Location], [ID], [Name], [Note], [Expression], [ModeEx], [IsSingle], [Flag],

[Caption], [iLeft], [iTop], [iWidth], [iHeight], [iCaptionLeft], [iCaptionWidth], [iPage],

[iRefSelect])
select * from  ufdata_002_2009.dbo.rpt_fltdef
set IDENTITY_INSERT ufdata_001_2009.dbo.rpt_fltdef  off

 

set IDENTITY_INSERT ufdata_001_2009.dbo.rpt_flddef  on
INSERT ufdata_001_2009.dbo.rpt_flddef
([ID_Field], [ID], [Name], [Expression], [Condition], [ModeEx], [OrderEx], [TopEx], [LeftEx],

[Width], [Height], [Visible], [Note], [nameForeign], [iColSize], [FormatEx], [iAlignStyle],

[iSize])
select * from     ufdata_002_2009.dbo.rpt_flddef
set IDENTITY_INSERT ufdata_001_2009.dbo.rpt_flddef  off

set IDENTITY_INSERT ufdata_001_2009.dbo.rpt_glbdef  on
INSERT ufdata_001_2009.dbo.rpt_glbdef
([ID], [SystemID], [Name], [Title], [DatabaseEx], [WhereEx], [Predicate], [Type], [Relation],

[Note], [Cols], [Section], [Fields], [DataSource], [BaseTable], [IsBaseTable],

[IsControlCreate], [IsBase], [GroupDefine])
select * from     ufdata_002_2009.dbo.rpt_glbdef
set IDENTITY_INSERT ufdata_001_2009.d

posted on 2009-08-10 17:48  martian6125  阅读(159)  评论(0编辑  收藏  举报