当前位置：首页 > 用友T6论坛 > 用友T6帐套升级报错约束 'PK_VoucherIte

用友T6帐套升级报错约束 'PK_VoucherIte

用友T6论坛40

我在使用用友T6企业管理软件的T6模块中碰到了一个奇怪的问题：

T6帐套升级报错

具体的情况如下：

约束 'PK_VoucherItems' 不属于表'voucheritems'。执行如下语句时出错:--voucheritems_base创建新的多语表,删除旧主建,建立新主键
Alter Table voucheritems Drop Constraint PK_VoucherItems
Execute sp_rename 'voucheritems','voucheritems_base','object'
--建聚集索引
CREATE CLUSTERED
INDEX [Idx_Main] ON [dbo].[voucheritems_base] ([CardNum], [vt_id])
--创建PK
Alter Table dbo.voucheritems_base Add Constraint
PK_VoucherItems Primary Key
(
AutoId
) on [Primary]
if not exists (select * from sysobjects where id = object_id('dbo.voucheritems_lang') and sysstat & 0xf = 3)
begin
create table voucheritems_lang
(guid varchar(50) not null,
localeid varchar(32),
vt_id int not null,
fieldname nvarchar(40),
cardsection nvarchar(4),
cardnum varchar(10),
carditemname nvarchar(30) null,
cardformula1 nvarchar(40) null,
cardformula2 nvarchar(40) null,
fontstate nvarchar(40) null DEFAULT ('宋体,9,0,0,1'),
ufts timestamp

)
CREATE CLUSTERED
INDEX [Idx_Main] ON [dbo].[voucheritems_lang] ([localeid], [vt_id]) Alter Table [dbo].[voucheritems_lang] Add Constraint
pk_voucheritems_lang Primary Key
(
guid
) on [Primary]
end