用友T6软件查询销售发货统计表,没有弹出过滤条件窗口
技术咨询，有偿服务！
复制微信号
查询销售发货统计表,没有弹出过滤条件窗口
原因分析：后台rpt_glbdef,rpt_flddef,rpt_fltdef 三个表记录缺失.
问题解答：1.备份好账套2. 在查询分析器中执行以下语句：--修复 rpt_glbdef,rpt_flddef,rpt_fltdef,原理：从正确账套导数据过来，ufdata_001_2012是无问题账套，ufdata_010_2012是存在问题账套delete from UFDATA_010_2012..rpt_glbdef set IDENTITY_INSERT UFDATA_010_2012..rpt_glbdef oninsert into UFDATA_010_2012..rpt_glbdef(ID,systemid,Name,title,databaseex,whereEx,predicate,type,relation,note,cols,[section],fields,datasource,basetable,isbasetable,iscontrolcreate,isbase,groupdefine) select ID,systemid,Name,title,databaseex,whereEx,predicate,type,relation,note,cols,[section],fields,datasource,basetable,isbasetable,iscontrolcreate,isbase,groupdefine from ufdata_001_2012..rpt_glbdefset IDENTITY_INSERT UFDATA_010_2012..rpt_glbdef offdelete from UFDATA_010_2012..rpt_flddefset IDENTITY_INSERT UFDATA_010_2012..rpt_flddef oninsert into UFDATA_010_2012..rpt_flddef(ID_Field,ID,Name,Expression,Condition,ModeEx,OrderEx,TopEx,LeftEx,Width,Height,Visible,Note,nameForeign,iColSize,FormatEx,iAlignStyle,iSize) select ID_Field,ID,Name,Expression,Condition,ModeEx,OrderEx,TopEx,LeftEx,Width,Height,Visible,Note,nameForeign,iColSize,FormatEx,iAlignStyle,iSize from UFDATA_001_2012..rpt_flddef set IDENTITY_INSERT UFDATA_010_2012..rpt_flddef off delete from UFDATA_010_2012..rpt_fltdefset IDENTITY_INSERT UFDATA_010_2012..rpt_fltdef oninsert into UFDATA_010_2012..rpt_fltdef(ID_Flt,Location,ID,Name,Note,Expression,ModeEx,IsSingle,Flag,Caption,iLeft,iTop,iWidth,iHeight,iCaptionLeft,iCaptionWidth,iPage,iRefSelect) select ID_Flt,Location,ID,Name,Note,Expression,ModeEx,IsSingle,Flag,Caption,iLeft,iTop,iWidth,iHeight,iCaptionLeft,iCaptionWidth,iPage,iRefSelect from UFDATA_001_2012..rpt_fltdefset IDENTITY_INSERT UFDATA_010_2012..rpt_fltdef off
如果您的问题还没有解决，或者在百度上找不到答案可以到右上角搜索中进行搜索。