|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
本帖最后由 yong198005 于 2010-4-13 14:46 编辑
希望各位大侠指点一下迷津!从哪方面入手啊!就差这年出问题,其他都很正常!
从u8普及版2.0升级到u890.
用友越做越麻烦了!
数据库名: UFDATA_001_2009
D:\U8SOFT\Admin\SQLFILE8600\Main\Ufdata\DPRO860_ST_ST.sql
错误信息:
-2147217900
第 33 行: 'lef?' 附近有语法错误。
执行如下语句时出错:
create view dbo.kcscrapdeallist
as
select dbo.kcscrapdealhead.id, dbo.kcscrapdealhead.vt_id,
dbo.kcscrapdealhead.cspcode, dbo.kcscrapdealhead.cvouchtype,
dbo.kcscrapdealhead.ddate,
dbo.kcscrapdealhead.ufts,
dbo.kcscrapdealhead.coutwhcode, dbo.kcscrapdealhead.cdepcode,
dbo.kcscrapdealhead.ccuscode, dbo.kcscrapdealhead.cvencode,
dbo.kcscrapdealhead.cpersoncode,
dbo.kcscrapdealhead.cordcode, dbo.kcscrapdealhead.cmemo,
dbo.kcscrapdealhead.cmaker, dbo.kcscrapdealhead.cverifyperson,
dbo.kcscrapdealhead.dverifydate, dbo.kcscrapdealhead.cchkcode,
dbo.kcscrapdealhead.dchkdate, dbo.kcscrapdealhead.cchkperson,
dbo.kcscrapdealhead.cdefine1, dbo.kcscrapdealhead.cdefine2,
dbo.kcscrapdealhead.cdefine3, dbo.kcscrapdealhead.cdefine4,
dbo.kcscrapdealhead.cdefine5, dbo.kcscrapdealhead.cdefine6,
dbo.kcscrapdealhead.cdefine7, dbo.kcscrapdealhead.cdefine8,
dbo.kcscrapdealhead.cdefine9, dbo.kcscrapdealhead.cdefine10,
dbo.kcscrapdealhead.cdefine11, dbo.kcscrapdealhead.cdefine12,
dbo.kcscrapdealhead.cdefine13, dbo.kcscrapdealhead.cdefine14,
dbo.kcscrapdealhead.cdefine15, dbo.kcscrapdealhead.cdefine16,
dbo.kcscrapdealhead.csource, dbo.kcscrapdealhead.cdinid, dbo.kcscrapdealhead.cwhname,
dbo.kcscrapdealhead.cdepname, dbo.kcscrapdealhead.ccusname,
dbo.kcscrapdealhead.cvenname, dbo.kcscrapdealhead.cpersonname,
dbo.kcscrapdealhead.crdname,
dbo.kcscrapdealhead.ctext, dbo.kcscrapdealbody.cinvname,
dbo.kcscrapdealbody.cinvaddcode, dbo.kcscrapdealbody.creplaceitem,
dbo.kcscrapdealbody.cinvstd, dbo.kcscrapdealbody.cposition,
dbo.kcscrapdealbody.cinvm_unit, dbo.kcscrapdealbody.cinvdefine1,
dbo.kcscrapdealbody.cinvdefine2, dbo.kcscrapdealbody.cinvdefine3,
dbo.kcscrapdealbody.cinvdefine4, dbo.kcscrapdealbody.cinvdefine5,
dbo.kcscrapdealbody.cinvdefine6, dbo.kcscrapdealbody.cinvdefine7,
dbo.kcscrapdealbody.cinvdefine8, dbo.kcscrapdealbody.cinvdefine9,
dbo.kcscrapdealbody.cinvdefine10, dbo.kcscrapdealbody.cinvdefine11,
dbo.kcscrapdealbody.cinvdefine12, dbo.kcscrapdealbody.cinvdefine13,
dbo.kcscrapdealbody.cinvdefine14, dbo.kcscrapdealbody.cinvdefine15,
dbo.kcscrapdealbody.cinvdefine16,dbo.kcscrapdealbody.iid, dbo.kcscrapdealbody.cbatch,
dbo.kcscrapdealbody.inum, dbo.kcscrapdealbody.iinvexchrate,
dbo.kcscrapdealbody.iquantity, dbo.kcscrapdealbody.iunitcost,
dbo.kcscrapdealbody.iprice, dbo.kcscrapdealbody.ipunitcost,
dbo.kcscrapdealbody.ipprice, dbo.kcscrapdealbody.cfree1,
dbo.kcscrapdealbody.cfree2, dbo.kcscrapdealbody.cfree3,
dbo.kcscrapdealbody.cfree4, dbo.kcscrapdealbody.cfree5,
dbo.kcscrapdealbody.cfree6, dbo.kcscrapdealbody.cfree7,
dbo.kcscrapdealbody.cfree8, dbo.kcscrapdealbody.cfree9,
dbo.kcscrapdealbody.cinva_unit, dbo.kcscrapdealbody.cfree10,
dbo.kcscrapdealbody.cinvcode, dbo.kcscrapdealbody.cbarcode,
dbo.kcscrapdealbody.cassunit, dbo.kcscrapdealbody.icheckids,
dbo.kcscrapdealbody.id as expr1, dbo.kcscrapdealbody.autoid,
dbo.kcscrapdealbody.cdefine22, dbo.kcscrapdealbody.cdefine23,
dbo.kcscrapdealbody.cdefine24, dbo.kcscrapdealbody.cdefine25,
dbo.kcscrapdealbody.cdefine26, dbo.kcscrapdealbody.cdefine27,
dbo.kcscrapdealbody.cdefine28, dbo.kcscrapdealbody.cdefine29,
dbo.kcscrapdealbody.cdefine30, dbo.kcscrapdealbody.cdefine31,
dbo.kcscrapdealbody.cdefine32, dbo.kcscrapdealbody.cdefine33,
dbo.kcscrapdealbody.cdefine34, dbo.kcscrapdealbody.cdefine35,
dbo.kcscrapdealbody.cdefine36, dbo.kcscrapdealbody.cdefine37,
dbo.kcscrapdealbody.citemcode, dbo.kcscrapdealbody.iarvids,
dbo.kcscrapdealbody.citem_class, dbo.kcscrapdealbody.cname,
dbo.kcscrapdealbody.ddealdate, dbo.kcscrapdealbody.cdealplace, dbo.kcscrapdealbody.cdealmode,
dbo.kcscrapdealbody.citemcname, dbo.kcscrapdealbody.cbvencode,
dbo.kcscrapdealbody.imassdate, dbo.kcscrapdealbody.dmadedate,dbo.kcscrapdealbody.cinvouchcode,
dbo.kcscrapdealbody.cvenname as expr2,dbo.kcscrapdealbody.cgspstate,dbo.kcscrapdealbody.rdsid ,dbo.kcscrapdealbody.dvdate,
dbo.kcscrapdealbody.cmassunit
from dbo.kcscrapdealhead inner join
dbo.kcscrapdealbody on dbo.kcscrapdealhead.id = dbo.kcscrapdealbody.id |
|