| 问题版本: |
76-用友通标准版10.3 |
问题模块: |
17-销售管理 |
| 所属行业: |
0-通用 |
问题状态: |
1-用友渠道公司帐户 |
| 关 键 字: |
发货明细表无法输出 |
适用产品: |
76 |
| 补 丁 号: |
|
开放状态: |
3-用友渠道公司帐户 |
| 原问题号: |
|
提交时间: |
2008-4-22 11:58:00 |
| 问题名称: |
发货明细表无法输出 |
| 问题现象: |
发货明细表无法按货物汇总输出,预览也无效，无任何提示，点了没有反映．但是按部门汇总时，可以输出，也可预览．请尽快处理，非常感谢！ |
| 原因分析: |
注意在有－－的地方分段 Begin Declare @cItemName varchar(20) Set @cItemName = (Select cItemName from userDef Where cID = '01') If @cItemName Is Null update rpt_flddef set Name = '自定义项1' where Expression = 'cDefine1' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) else update rpt_flddef set Name = @cItemName where Expression = 'cDefine1' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) Set @cItemName = (Select cItemName from userDef Where cID = '02') If @cItemName Is Null update rpt_flddef set Name = '自定义项2' where Expression = 'cDefine2' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表 |
| 解决方案: |
注意在有－－的地方分段 Begin Declare @cItemName varchar(20) Set @cItemName = (Select cItemName from userDef Where cID = '01') If @cItemName Is Null update rpt_flddef set Name = '自定义项1' where Expression = 'cDefine1' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) else update rpt_flddef set Name = @cItemName where Expression = 'cDefine1' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) Set @cItemName = (Select cItemName from userDef Where cID = '02') If @cItemName Is Null update rpt_flddef set Name = '自定义项2' where Expression = 'cDefine2' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) else update rpt_flddef set Name = @cItemName where Expression = 'cDefine2' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) end --重新排序 Begin Declare @ID_Field int Declare @iOrderEx int Set @iOrderEx = 0 Declare Fld_Cur Cursor For Select ID_Field from Rpt_FldDEF Where Id = 1360 And ModeEx = 0 order by OrderEx Open Fld_cur Fetch Next FROM Fld_Cur Into @ID_Field WHILE @@FETCH_STATUS = 0 Begin Set @iOrderEx = @iOrderEx + 1 Update Rpt_FldDef Set OrderEx = @iOrderEx Where Id = 1360 And ModeEx = 0 And ID_Field = @ID_Field Fetch Next FROM Fld_Cur Into @ID_Field End CLOSE Fld_Cur DEALLOCATE Fld_Cur End | |
