金蝶错误修复方法.docVIP

  • 185
  • 0
  • 约1.84万字
  • 约 21页
  • 2016-10-20 发布于河南
  • 举报
金蝶错误修复方法

金蝶错误修复方法 C:\Windows\System32\Netplwiz.exe C:\Windows\System32\netsh.exe 金蝶错误解决 1、---------------------------------------------------------------------------------------------------------------------------------- 错误代码:3639(E37H) Source :Microsoft OLE DB Provider for SQL Server Detail :对象名 t_FADeprPolicy 无效。 或----------------------------------------------------------------------------------------------------------------------------------- 打开科目时,只显示资产和负债两个类别,提示:类型不匹配 错误代码:13(DH) Source :SystemDataLib 成功的解决方法: IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N[t_FADeprPolicy]) and OBJECTPROPERTY(id, NIsUserTable) = 1) BEGIN CREATE TABLE [t_FADeprPolicy] ( [FID] [int] IDENTITY (1, 1), [FNumber] [nvarchar](80) NOT NULL , [FName] [nvarchar](80) NOT NULL , [FLevel] [int] NOT NULL , [FParentId] [int] NOT NULL , [FDetail] [smallint] NOT NULL , [FAddDeprPolicy] [smallint] NOT NULL DEFAULT (0), [FAlterDeprPolicy] [smallint] NOT NULL DEFAULT (0), [FClearDeprPolicy] [smallint] NOT NULL DEFAULT (0), [FDefault] [smallint] NOT NULL DEFAULT (0) ) ON [PRIMARY] END IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and o.name=t_FaCard and c.Name=FDeprPolicyID) Alter TABLE [t_FaCard] Add FDeprPolicyID [int] NOT NULL DEFAULT (1) IF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and o.name=t_fabalcard and c.Name=FCurrentEffect) alter table t_fabalcard add FCurrentEffect [smallint] NOT NULL DEFAULT (0) IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N[vw_fa_card]) and OBJECTPROPERTY(id, NIsView) = 1) Begin Drop View vw_fa_card End GO CREATE VIEW vw_fa_card AS select al.FAlterID,al.FAssetID,al.FYear,al.FPeriod,al.FCleared,al.FNew,al.FAlterNum, al.FOtherAlter,al.FDate,al.FNeedVoucher,al.FExplanation,al.FPreparer, al.FChecker,card.FAssetNumber,card.FAssetName,card.FUnit,card.FModel, card.FManufacturer,card.FProductingArea,card.FVender

文档评论(0)

1亿VIP精品文档

相关文档