在金蝶专业版核算项目新增时,出现如下错误提示:
定义的应用程序或对象错误!
错误代码:3639(E37H) Source :EBSGLItem.ItemUpdate.Create Detail :对象名 'Access_t_ItemDefine' 无效。
解决方法:将下列代码在SQL SERVER中运行一下
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] WITH NOCHECK ADD CONSTRAINT [PK_Access_t_ItemDefine] PRIMARY KEY CLUSTERED ( [FItemID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Access_t_ItemDefine] ADD CONSTRAINT [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 |