升级报错

iufida

872升级到810报错<br />
数据库名: UFDATA_001_2007<br />
D:\U8SOFT\Admin\SQLFILE8900\Main\Ufdata\Structure\Data_PRV_EX_mix_NL.sql<br />
错误信息:<br />
-2147217865<br />
对象名 ＇ex_ciqinv＇ 无效。<br />
执行如下语句时出错:<br />
create view v_ex_ciqbookim as   <br />
select ex_ciqbookim.id,ex_ciqbookim.irowno,ex_ciqbookim.autoid,ex_ciqbookim.cinvcode,  <br />
ex_ciqbookim.cvencode, vendor.cvenname,   <br />
ex_ciqinv.cciqinvname as cinvname,ex_ciqinv.cciqcode,ex_ciqarchive.cciqname,ex_ciqinv.cciqinvstd as cinvstd,  <br />
ex_ciqinv.cciqunitcode as ccomunitcode ,computationunit.ccomunitname,  <br />
ex_ciqbookim.cnationcode,null as cnationname,ex_ciqbookim.fquantity,ex_ciqbookim.fprice,  <br />
ex_ciqbookim.fnatprice,ex_ciqbookim.fmoney,ex_ciqbookim.fnatmoney,ex_ciqbookim.ftransferinquantity,ex_ciqbookim.ftransferoutquantity,  <br />
ex_ciqbookim.clevyproperty,ex_ciqbookim.finquantity,ex_ciqbookim.foutquantity,ex_ciqbookim.cnote,ex_ciqbookim.cnapeitem,<br />
ex_ciqbookim.frejectqty,ex_ciqbookim.fotheroutqty,ex_ciqbookim.fotherinqty   <br />
from ex_ciqbookim left join ex_ciqinv on ex_ciqbookim.cinvcode=ex_ciqinv.cciqinvcode  <br />
left join vendor on ex_ciqbookim.cvencode=vendor.cvencode   <br />
left join ex_ciqarchive on ex_ciqinv.cciqcode=ex_ciqarchive.cciqcode   <br />
left join computationunit on ex_ciqinv.cciqunitcode=computationunit.ccomunitcode

a_minggrace

我也遇到此问题，怎么解决呀，不能说详细点呀！