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

最新推荐文章于 2019-07-25 16:40:35 发布

转载最新推荐文章于 2019-07-25 16:40:35 发布 · 79 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/martian6125/archive/2009/08/10/9631256.html

本文介绍了一种通过SQL操作来解决调拨单等单据定位功能中过滤条件缺失的问题。具体步骤包括清空问题账套中的配置表，并从新建账套中导入正确的配置数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

转载于:https://www.cnblogs.com/martian6125/archive/2009/08/10/9631256.html