用友建立年度账时 对象名TAX-SB-NSSB-BJ-ZB无效

zyxhlwc001

用友建立年度账时 对象名TAX-SB-NSSB-BJ-ZB无效怎么处理

hy1985hy

select * into ufdata_017_2014..TAX_SB_NSSB_BJ_ZB from ufdata_999_2011..TAX_SB_NSSB_BJ_ZB
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_FB1 from ufdata_999_2011..TAX_SB_NSSB_BJ_FB1
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_FB2 from ufdata_999_2011..TAX_SB_NSSB_BJ_FB2
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_FB3 from ufdata_999_2011..TAX_SB_NSSB_BJ_FB3
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_FB4 from ufdata_999_2011..TAX_SB_NSSB_BJ_FB4
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_GDZC from ufdata_999_2011..TAX_SB_NSSB_BJ_GDZC
select * into ufdata_017_2014..TAX_SB_NSSB_SH_ZB from ufdata_999_2011..TAX_SB_NSSB_SH_ZB
select * into ufdata_017_2014..TAX_SB_NSSB_SH_FB1 from ufdata_999_2011..TAX_SB_NSSB_SH_FB1
select * into ufdata_017_2014..TAX_SB_NSSB_SH_FB2 from ufdata_999_2011..TAX_SB_NSSB_SH_FB2
select * into ufdata_017_2014..TAX_SB_NSSB_SH_FB3 from ufdata_999_2011..TAX_SB_NSSB_SH_FB3
select * into ufdata_017_2014..TAX_SB_NSSB_SH_FB4 from ufdata_999_2011..TAX_SB_NSSB_SH_FB4
select * into ufdata_017_2014..TAX_SB_NSSB_SH_GDZC from ufdata_999_2011..TAX_SB_NSSB_SH_GDZC
select * into ufdata_017_2014..TAX_SB_NSSB_SH_YGZ_FB1 from ufdata_999_2011..TAX_SB_NSSB_SH_YGZ_FB1
select * into ufdata_017_2014..TAX_SB_NSSB_SH_YGZ_FB2 from ufdata_999_2011..TAX_SB_NSSB_SH_YGZ_FB2
select * into ufdata_017_2014..TAX_SB_XGM_BJ_ZB from ufdata_999_2011..TAX_SB_XGM_BJ_ZB
select * into ufdata_017_2014..TAX_SB_XGM_BJ_FB1 from ufdata_999_2011..TAX_SB_XGM_BJ_FB1
select * into ufdata_017_2014..TAX_SB_XGM_SH_ZB from ufdata_999_2011..TAX_SB_XGM_SH_ZB
select * into ufdata_017_2014..TAX_SB_XGM_SH_FB1 from ufdata_999_2011..TAX_SB_XGM_SH_FB1
select * into ufdata_017_2014..celldata_zcfz from ufdata_999_2011..celldata_zcfz
select * into ufdata_017_2014..celldata_lrb from ufdata_999_2011..celldata_lrb
select * into ufdata_017_2014..celldata_xjll from ufdata_999_2011..celldata_xjll

zyxhlwc001

怎么没人回到呀。自己顶一个。

承德yonyou

这是应该是指的表中某一个字段，请在建立年度账之前，备份好账套，打上当前版本的最新补丁，执行以下。在进行操作；
在系统管理中，对当前年度进行升级，再建立年度帐试试

zgfwyy

承德yonyou 发表于 2016-1-12 15:52
这是应该是指的表中某一个字段，请在建立年度账之前，备份好账套，打上当前版本的最新补丁，执行以下。在进 ...

请问哪里去升级？打补丁？

承德yonyou

zgfwyy 发表于 2016-1-14 09:58
请问哪里去升级？打补丁？

http://service.chanjet.com/product  产品更新

hy1985hy

select * into ufdata_017_2014..TAX_SB_NSSB_BJ_ZB from ufdata_999_2011..TAX_SB_NSSB_BJ_ZB
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_FB1 from ufdata_999_2011..TAX_SB_NSSB_BJ_FB1
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_FB2 from ufdata_999_2011..TAX_SB_NSSB_BJ_FB2
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_FB3 from ufdata_999_2011..TAX_SB_NSSB_BJ_FB3
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_FB4 from ufdata_999_2011..TAX_SB_NSSB_BJ_FB4
select * into ufdata_017_2014..TAX_SB_NSSB_BJ_GDZC from ufdata_999_2011..TAX_SB_NSSB_BJ_GDZC
select * into ufdata_017_2014..TAX_SB_NSSB_SH_ZB from ufdata_999_2011..TAX_SB_NSSB_SH_ZB
select * into ufdata_017_2014..TAX_SB_NSSB_SH_FB1 from ufdata_999_2011..TAX_SB_NSSB_SH_FB1
select * into ufdata_017_2014..TAX_SB_NSSB_SH_FB2 from ufdata_999_2011..TAX_SB_NSSB_SH_FB2
select * into ufdata_017_2014..TAX_SB_NSSB_SH_FB3 from ufdata_999_2011..TAX_SB_NSSB_SH_FB3
select * into ufdata_017_2014..TAX_SB_NSSB_SH_FB4 from ufdata_999_2011..TAX_SB_NSSB_SH_FB4
select * into ufdata_017_2014..TAX_SB_NSSB_SH_GDZC from ufdata_999_2011..TAX_SB_NSSB_SH_GDZC
select * into ufdata_017_2014..TAX_SB_NSSB_SH_YGZ_FB1 from ufdata_999_2011..TAX_SB_NSSB_SH_YGZ_FB1
select * into ufdata_017_2014..TAX_SB_NSSB_SH_YGZ_FB2 from ufdata_999_2011..TAX_SB_NSSB_SH_YGZ_FB2
select * into ufdata_017_2014..TAX_SB_XGM_BJ_ZB from ufdata_999_2011..TAX_SB_XGM_BJ_ZB
select * into ufdata_017_2014..TAX_SB_XGM_BJ_FB1 from ufdata_999_2011..TAX_SB_XGM_BJ_FB1
select * into ufdata_017_2014..TAX_SB_XGM_SH_ZB from ufdata_999_2011..TAX_SB_XGM_SH_ZB
select * into ufdata_017_2014..TAX_SB_XGM_SH_FB1 from ufdata_999_2011..TAX_SB_XGM_SH_FB1
select * into ufdata_017_2014..celldata_zcfz from ufdata_999_2011..celldata_zcfz
select * into ufdata_017_2014..celldata_lrb from ufdata_999_2011..celldata_lrb
select * into ufdata_017_2014..celldata_xjll from ufdata_999_2011..celldata_xjll
从演示里把没有的表导过去就可以了，是少表了，我以前遇到过几回了，把账套号与年度改下就可以了

zyxhlwc001

执行了select * into ufdata_017_2014..TAX_SB_NSSB_BJ_ZB from ufdata_999_2011..TAX_SB_NSSB_BJ_ZB
等相关语句显示0行被改动（MSDEdos下和sql2000下都执行了的。）或提示已有对象。打了补丁并对该年帐套数据升级，再建年度帐，还是那个提示。后来发现该帐去年年结时出问题后把他拷贝到别的电脑T3标准版10.82中结的帐套，本身电脑为普及版10.82.   后来在笔记本上T3普及版10.82下引入该帐套，直接进入系统管理进行SQL数据库升级后，OK.  再在打了补丁的电脑上sqL数据库升级也OK.  等于是跳过了其他步骤，直接升级的SQL数据库