金蝶错误修复方法.docx

金蝶错误修复方法


C:\Windows\System32\Netplwiz.exeC:\Windows\System32\netsh.exe金蝶错误解决1、----------------------------------------------------------------------------------------------------------------------------------错误代码:3639(E37H)Source :Microsoft OLE DB Provider for SQL ServerDetail :对象名 't_FADeprPolicy' 无效。或-----------------------------------------------------------------------------------------------------------------------------------打开科目时，只显示资产和负债两个类别，提示：类型不匹配错误代码:13(DH)Source :SystemDataLib成功的解决方法：IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[t_FADeprPolicy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)BEGINCREATE 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]ENDIF NOT EXISTS(SELECT 1 FROM sysobjects o, syscolumns c where o.id=c.id and https://www.sodocs.net/doc/0418059181.html ='t_FaCard' and https://www.sodocs.net/doc/0418059181.html ='FDeprPolicyID')Alter TABLE [t_FaCard] Add FDeprPolicyID [int] NOT NULL DEFAULT