| 自動編號: | 19417 | 產品版本: | 通2005 |
| 產品模塊: | 總賬 | 所屬行業: | 通用 |
| 適用產品: | 關 鍵 字: | ||
| 問題名稱: | 發貨明細表功能錯誤 | ||
| 問題現象: | 發貨明細表（按存貨查詢）不能輸出 | ||
| 原因分析: | 可能是數據庫中各表之間有錯誤 | ||
| 解決方案: | 執行腳本： 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 = 1362 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 = 1362 And ModeEx = 0 And ID_Field = @ID_Field Fetch Next FROM Fld_Cur Into @ID_Field End CLOSE Fld_Cur DEALLOCATE Fld_Cur DELETE FROM Rpt_FldDEF Where Id = 1362 And ModeEx = 0 And Expression = 'cDefine22' End
| ||