在增加其他应付款的核算项目时无法填加新职员
增加时 回提示
定义的应用程序或对象错误
错误代码？3639（E37H）
source:KISEBSBase.DataAccess:CreateData
Detail:对象名‘Access-t-Itemdefine'
无效
怎么解决啊 说的详细些
谢谢回答好的有高分酬谢
解决方案:
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
对应账套数据库执行一下上述代码
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
对应账套数据库执行一下上述代码
温馨提示：答案为网友推荐，仅供参考
