用友畅捷通T3普及版10.9升级到T3标准版11.2,dbo.fa_Q_YNZCTJB1无效

⽤友畅捷通T3普及版10.9升级到T3标准版

11.2,_Q_YNZCTJB1⽆效

⽤友畅捷通T3普及版10.9升级到T3标准版11.2,'_Q_YNZCTJB1' ⽆效

---------------------------

错误信息 升级到 T3-标准版11.1

---------------------------

数据库名: UFDATA_001_2017系统管理错误信息:-2147217865对象名 '_Q_YNZCTJB1' ⽆效。执⾏如下语句时出错:----逾龄资

产统计表婴幼儿奶粉排行榜 查询ALTER Proc [dbo].[fa_Q_YNZCTJB1](@LoginDate DateTime, @LoginPeriod int ) AS if exists (lect * from

ects where id = object_id(N'[fa_Q_YNZCTJB1024]') and OBJECTPROPERTY(id, N'IsTable') = 1)begindrop table

[fa_Q_YNZCTJB1024]---endlect * into fa_Q_YNZCTJB1024 from (SELECT '1' AS sSort,fa_D, @LoginDate AS

dDate, fa_um AS sCardNum, fa_Num, fa_Name, fa_,

fa_, fa_date, CONVERT(varchar(4),[fa_Cards].[lLife]/12) + '年' + (CASE WHEN [fa_Cards].

[lLife]%12>0 THEN CONVERT(varchar(4),[fa_Cards].[lLife]%12) + '⽉' ELSE '' END) AS sLife, fa_ue, (CASE

@LoginPeriod WHEN 1 THEN [dblDeprT1] WHEN 2 THEN [dblDeprT2] WHEN 3 THEN [dblDeprT3] WHEN 4 THEN

[dblDeprT4] WHEN 5 THEN [dblDeprT5] WHEN 6 THEN [dblDeprT6] WHEN 7 THEN [dblDeprT7] WHEN 8 THEN [dblDe

---------------------------

确定

---------------------------

以上错误信息提⽰,在畅捷通⽀持⽹站有个说明,需要降级就可以,我执⾏了降级发现还有有个错误,先说这个错误的解决脚本如下:

update accinformation t cvalue=chuangye '8.216',cdefault='8.216' where cname='versionflag'

if exists (lect * from ects where id = object_id(N'[dbo].[Rpt_FldDEF]') and OBJECTPROPERTY(id, N'IsUrTable') = 1)

lect * ld1 from rpt_flddef

GO

if exists (lect * from ects where id = object_id(N'[dbo].[Rpt_FldDEF]') and OBJECTPROPERTY(id, N'IsUrTable') = 1)

drop table [dbo].[Rpt_FldDEF]

GO

CREATE TABLE [dbo].[Rpt_FldDEF] (

[ID_Field] [int] IDENTITY (1, 1) NOT NULL ,

[ID] [int] NULL ,

[Name] [varchar] (32) COLLATE Chine_PRC_CI_AS NULL ,

[Expression] [varchar] (255) COLLATE Chine_PRC_CI_AS NULL ,

[Condit秋季景色 ion] [varchar] 肚子疼吃什么 (255) COLLATE Chine_PRC_CI_AS NULL ,

[ModeEx] [int] NULL ,

[ModeEx] [int] NULL ,

[OrderEx] [int] NULL ,

[TopEx] [int] NULL ,

[LeftEx] [int] NULL ,

[Width] [int] NULL ,

[Height] [int] NULL ,

[怎么入党 Visible] [int] NULL ,

[Note] [varchar] (32) COLLATE Chine_PRC_CI_AS NULL ,

[nameForeign] [varchar] (32) COLLATE Chine_PRC_CI_AS NULL ,

[iColSize] [int] NULL ,

[FormatEx] [varchar] (20) COLLATE Chine_PRC_CI_AS NULL ,

[iAlignStyle] [int] NULL ,

[iSize] [int] NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Rpt_FldDEF] WITH NOCHECK ADD

CONSTRAINT [Rpt_FldDEF_PK] PRIMARY KEY CLUSTERED

(

[ID_Field]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Rpt_FldDEF] ADD

CONSTRAINT [DF__Rpt_FldDe__iColS__76B76416] DEFAULT (0) FOR [iColSize],

CONSTRAINT [DF__Rpt_FldDe__iAlig__77AB884F] DEFAULT (0) FOR [iAlignStyle],

CONSTRAINT [DF__Rpt_FldDe__二年级应用题大全800题 iSize__789FAC88] DEFAULT (0) FOR [iSize]

GO

CREATE INDEX [ID] ON [dbo].[Rpt_FldDEF]([ID]) ON [PRIMARY]

GO

CREATE UNIQUE INDEX [ID_Field] ON [dbo].[Rpt_FldDEF]([ID_Field]) ON [PRIMARY]

GO

tur

GO

EXEC sp_bindefault N'[dbo].[Rpt_FldDEF_Height_D]', N'[Rpt_FldDEF].[Height]'

GO

EXEC sp_bindefault N'[dbo].[Rpt_FldDEF_ID_D]', N'[Rpt_FldDEF].[ID]'

GO

EXEC sp_bindefault N'[dbo].[Rpt_FldDEF_LeftEx_D]', N'[Rpt_FldDEF].[LeftEx]'

GO

EXEC sp_bindefault N'[dbo].[Rpt_FldDEF_ModeEx_D]', N'[Rpt_FldDEF].[ModeEx]'

GO

EXEC sp_bindefault N'[dbo].[Rpt_FldDEF_OrderEx_D]', N'[Rpt_FldDEF].[OrderEx]'

GO

EXEC sp_bindefault N'[dbo].[Rpt_FldDEF_TopEx_D]', N'[Rpt_个人管理 FldDEF].[TopEx]'

GO

EXEC sp_bindefault N'[dbo].[Rpt_FldDEF_Visible_D]', N'[Rpt_FldDEF].[Visible]'

GO

EXEC sp_bindefault N'[dbo].[Rpt_FldDEF_Width_D]', N'[Rpt_FldDEF].[Width]'

GO

tur

GO

t identity_inrt Rpt_FldDEF on

inrt into _FldDEF(ID_Field, ID, Name, Expression, Condition, ModeEx, OrderEx, TopEx, LeftEx, Width, Height, Visible, Note, nameForeign, iColSize, Fo

-- lect *

ld1

t identity_inrt Rpt_FldDE下火茶有哪些 F off

go

if exists (lect * from tempdb..sysobjects where name='yld1')

drop ld1

GO

lect iD_Field, ID, Name, Expression, Condition, ModeEx, OrderEx, TopEx, LeftEx, Width, Height, Visible, Note, nameForeign, iColSize, FormatEx, iAlignStyle, iS

执⾏完这个脚本之后,重新打开系统管理升级sql,会有下⾯错误.

---------------------------

错误信息 升级到 T3-⽤友通10.8plus1

---------------------------

数据库名: UFDATA_001_2017系统管理错误信息:-2147217833将截断字符串或

⼆进制数据。执⾏如下语句时出错:if exists (lect * from

ects where id = object_id(N'[dbo].[tmpGL_blreq]') and

OBJECTPROPERTY(id, N'IsUrTable') = 1)begin inrt into GL_blreq

(cf_id,cf_name,Description) lect cf_id,cf_name,Description from

tmpGL_blreq drop table [dbo].[tmpGL_blreq] endif not exists

(lect * from sysobjects inner join syscolumns on =

where = 'GL_bfreq' and =

'U' and = 'cf_n男性左下腹疼痛 a良妃 me') Alter table GL_bfreq add

cf_name varchar(50) if not exists(lect * from sysobjects inner join

syscolumns on = where =

'GL_bfreq' and = 'U' and = 'IsYx')

Alter table GL_bfreq add IsYx varchar(2) ---------------------------

确定

---------------------------

****解决办法***错误原因是常⽤凭证表有问题,因为降级回去之后⽼版本是没有常⽤凭证分类的.

delete GL_bfreq

delete GL_blreq

删除之后,重新执⾏就OK