问题现象: | 客户将原U852软件中帐套号为888的2004年度帐升级至U872过程中出现很多报错,请支持将该年度帐升级至U872。帐套已上传至FTP,名称为:常州分公司-王刚-u872-SQl2000-系统管理.rar |
问题原因: | |
解决方案: | 您好,在04年数据库中执行如下脚本后再升级(请将逗号,括号改为英文状态的对应符号): select * into voucheritems_bak from voucheritems go drop Table voucheritems go CREATE TABLE [VoucherItems] ( [autoid] [int] IDENTITY (1, 1) NOT NULL , [VT_ID] [int] NULL CONSTRAINT [DF__VoucherIt__VT_ID__37B0FECB] DEFAULT (0), [CardNum] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [CardItemNum] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NULL , [CardItemName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [CanNotSelect] [bit] NULL , [ShowIt] [bit] NULL , [LinkIt] [smallint] NULL , [LinkTbl] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [LinkField] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [TableName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [FieldName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [FieldType] [smallint] NULL , [ReferType] [smallint] NULL , [ReferTable] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [CardSection] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL , [CardFormula1] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [CardFormula2] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [CanModify] [bit] NULL , [MaxLength] [int] NULL , [MaxShowLen] [int] NULL , [NumPoint] [int] NULL , [IsNull] [bit] NULL , [CanDelete] [int] NULL , [UserCheck] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [UserPrompt] [varchar] (28) COLLATE Chinese_PRC_CI_AS NULL , [FormatChar] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__VoucherIt__Forma__38A52304] DEFAULT (1), [IsMain] [bit] NULL , [NeedSum] [smallint] NULL , [CalcField] [bit] NULL , [AliasNum] [smallint] NULL , [isSelfDef] [int] NULL , [COX] [int] NULL , [COY] [int] NULL , [Width] [int] NULL , [Height] [int] NULL , [TabIndex] [int] NULL , [DefaultValue] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [IsFixedLenght] [bit] NULL , [FormatData] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [FontState] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__VoucherIt__FontS__3999473D] DEFAULT ('宋体,9,0,0,1'), [PrintCaption] [bit] NULL CONSTRAINT [DF__VoucherIt__Print__3A8D6B76] DEFAULT (1), [PrintUpcase] [bit] NULL CONSTRAINT [DF__VoucherIt__Print__3B818FAF] DEFAULT (0), [PrintInterval] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [DataSource] [int] NULL CONSTRAINT [DF__VoucherIt__DataS__3C75B3E8] DEFAULT (0), [EnterType] [int] NULL CONSTRAINT [DF__VoucherIt__Enter__3D69D821] DEFAULT (0), [DataRule] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL , [ValidityCheck] [bit] NULL CONSTRAINT [DF__VoucherIt__Valid__3E5DFC5A] DEFAULT (0), [ReserveSegTitlePos] [bit] NULL CONSTRAINT [DF__VoucherIt__Reser__3F522093] DEFAULT (1), [BuildArchives] [bit] NULL CONSTRAINT [DF__VoucherIt__Build__404644CC] DEFAULT (0), [ReferReturnField] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL , [cmemo] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL , [nBorder] [int] NULL CONSTRAINT [DF__VoucherIt__nBord__413A6905] DEFAULT (0), [pubufts] [binary] (8) NULL , CONSTRAINT [PK_VoucherItems] PRIMARY KEY CLUSTERED ( [autoid] ) ON [PRIMARY] ) ON [PRIMARY] GO INSERT INTO [VoucherItems]([VT_ID], [CardNum], [CardItemNum], [CardItemName], [CanNotSelect], [ShowIt], [LinkIt], [LinkTbl], [LinkField], [TableName], [FieldName], [FieldType], [ReferType], [ReferTable], [CardSection], [CardFormula1], [CardFormula2], [CanModify], [MaxLength], [MaxShowLen], [NumPoint], [IsNull], [CanDelete], [UserCheck], [UserPrompt], [FormatChar], [IsMain], [NeedSum], [CalcField], [AliasNum], [isSelfDef], [COX], [COY], [Width], [Height], [TabIndex], [DefaultValue], [IsFixedLenght], [FormatData], [FontState], [PrintCaption], [PrintUpcase], [PrintInterval], [DataSource], [EnterType], [DataRule], [ValidityCheck], [ReserveSegTitlePos], [BuildArchives], [ReferReturnField], [cmemo], [nBorder]) select [VT_ID], [CardNum], [CardItemNum], [CardItemName], [CanNotSelect], [ShowIt], [LinkIt], [LinkTbl], [LinkField], [TableName], [FieldName], [FieldType], [ReferType], [ReferTable], [CardSection], [CardFormula1], [CardFormula2], [CanModify], [MaxLength], [MaxShowLen], [NumPoint], [IsNull], [CanDelete], [UserCheck], [UserPrompt], [FormatChar], [IsMain], [NeedSum], [CalcField], [AliasNum], [isSelfDef], [COX], [COY], [Width], [Height], [TabIndex], [DefaultValue], [IsFixedLenght], [FormatData], [FontState], [PrintCaption], [PrintUpcase], [PrintInterval], [DataSource], [EnterType], [DataRule], [ValidityCheck], [ReserveSegTitlePos], [BuildArchives], [ReferReturnField], [cmemo], [nBorder] from VoucherItems_bak go drop table VoucherItems_bak 若有问题,请及时反馈! U8/CRM/PLM |
相关补丁: | |
版本: | 8.72 |
模块: | 数据库 |
产品: | 系统工具及环境 |
问题名称: | 帐套升级 |
最后更新: | 2011-10-09 08:47:56 |