KSQL中 left join table(f_attachlist(b.fid))报错!!!
金蝶云社区-188xxxx1508
188xxxx1508
1人赞赏了该文章 1,175次浏览 未经作者许可,禁止转载编辑于2015年04月25日 15:54:12

var sql = " select b.fid ";
sql += " from CT_CUS_GSSB a ";
sql += " inner join CT_CUS_GSSBEntry b on a.fid = b.fparentid ";
sql += " left join table(f_attachlist(b.fid)) c on c.id = b.fid ";
sql += " where a.fid='" + detailid + "'";
在onload后置脚本中设置后,执行时提示
Caused exception message is: null
Caused exception message is: translate sql exception, message is
parse error. detail message is :

Error: expect token , but current token is , at line 1, column 100)
source sql is :
select b.fid from CT_CUS_GSSB a inner join CT_CUS_GSSBEntry b on a.fid = b.fparentid left join table(f_attachlist(b.fid)) c on c.id = b.fid where a.fid='Oumc/2tlTfusd4jXbvGTEavXMs0='
错误详细堆栈信息:com.kingdee.eas.ep.plugin.ScriptExecuteException: Plugin script execute error, please check whether script is right.
方案GS01中的脚本存在问题。
什么原因啊?