|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
各位大侠些,U6V3.2结转供销链时,提示如下错误:
经跟踪,发现是结转过程中执行的脚本有语法错误,跟踪脚本如下:
INSERT INTO QM_NCheckVoucher(CVOUCHTYPE, ID, CCHECKCODE, CSOURCE, DDATE, CTIME, CDEPCODE, CDEFINE1, CDEFINE2, CDEFINE3, CDEFINE4,
CDEFINE5, CDEFINE6, CDEFINE7, CDEFINE8, CDEFINE9, CDEFINE10, CDEFINE11, CDEFINE12, CDEFINE13, CDEFINE14, CDEFINE15, CDEFINE16,
CCHECKPERSONCODE, CMAKER, CVERIFIER, IVTID, BPUINFLAG, BPROINFLAG, BREJFLAG, BSTNEXTYEAR, dVerifierDate, bOMInFlag, cSourceCardNumber,
cVouchName, cCusCode, cProductDepCode, cvencode, bChkFirst) SELECT CVOUCHTYPE, ID, CCHECKCODE, CSOURCE, DDATE, CTIME, CDEPCODE,
CDEFINE1, CDEFINE2, CDEFINE3, CDEFINE4, CDEFINE5, CDEFINE6, CDEFINE7, CDEFINE8, CDEFINE9, CDEFINE10, CDEFINE11, CDEFINE12, CDEFINE13,
CDEFINE14, CDEFINE15, CDEFINE16, CCHECKPERSONCODE, CMAKER, CVERIFIER, IVTID, BPUINFLAG, BPROINFLAG, BREJFLAG, BSTNEXTYEAR,
dVerifierDate, bOMInFlag, cSourceCardNumber, cVouchName, cCusCode, cProductDepCode, cvencode, 1 as bChkFirst
FROM UFDATA_002_2013..QM_Ncheckvoucher cv
where cv.id in (select distinct cv.id from UFDATA_002_2013..qm_ncheckvoucher cv
left outer join UFDATA_002_2013..qm_ncheckvouchers cv_s on cv.id=cv_s.id where (cv.cvouchtype='QM12' and cv_s.isourceid in
(select distinct dlid as isourceid from UFDATA_002_2014dispatchlist) ) )
红色部分正确语法:ufdata_002_2014..dispatchlist
有相关补丁的大侠们,望不吝见赐!万分感谢!124301008@qq.com
|
|