|
楼主(阅:67948/回:1)KIS专业版8.1允许负结存如何控制KIS专业版 8.1允许负结存如何控制 欢迎访问金蝶销售服务中心02787739355
|
|
此问题的原因是由于 Access_t_ItemDefine表中丢失了相关记录,目前通过以下 SQL 修复: --Begin 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 --End 欢迎访问金蝶销售服务中心02787739355
回复1楼 TOP
|
1/ 1 1
|