问题解决

栏目:kis知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

问题解决

金蝶商贸版6.1删除凭证提示错误代码3639(E37H)
SOURCE :MICROSOFT OLB DB PROVIDER FOR SQL SERVER
DETAIL:对象名 t-FACLEAR 无效。解决方法。
执行语句if
exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[Access_t_ItemDefine]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [dbo].[Access_t_ItemDefine]
GO
CREATE TABLE [dbo].[Access_t_ItemDefine] ([FItemID] [int] NOT NULL , [FParentIDX] [int] NOT NULL , [FDataAccessDelete][binary] (100) NOT NULL , [FDataAccessEdit] [binary] (100) NOT NULL ,[FDataAccessView] [binary] (100) NOT NULL ) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Access_t_ItemDefine] WITHNOCHECK ADD CONSTRAINT [PK_Access_t_ItemDefine] PRIMARY KEY CLUSTERED ([FItemID] ) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Access_t_ItemDefine] ADDCONSTRAINT [DF_Access_t_ItemDefine_FDataAccessDelete] DEFAULT (0) FOR[FDataAccessDelete], CONSTRAINT [DF_Access_t_ItemDefine_FDataAccessEdit]DEFAULT (0) FOR [FDataAccessEdit], CONSTRAINT[DF_Access_t_ItemDefine_FDataAccessView] DEFAULT (0) FOR [FDataAccessView]
GO


您好 建议您直接上传账套到总部进行检查。
谢谢

问题解决

金蝶商贸版6.1删除凭证提示错误代码3639(E37H) SOURCE :MICROSOFT OLB DB PROVIDER FOR SQL SERVER DETAIL:对象名 t-FACLEAR...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息