调拨单等单据定位功能没有过滤条件-优快云博客

本文介绍了一种通过清空并重新填充数据库表的方法来解决调拨单等单据定位功能的问题，具体涉及删除和重建与报表过滤条件相关的数据。

/*调拨单等单据定位功能没有过滤条件
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