sql ... Caused exception message is: index: 1, size: 0

最新推荐文章于 2022-05-07 10:48:10 发布

lym_one

最新推荐文章于 2022-05-07 10:48:10 发布

阅读量601

点赞数

分类专栏： kingdee-report 文章标签： sql exception join 报表 null im

本文链接：https://blog.csdn.net/lym_one/article/details/4566949

版权

kingdee-report 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

普通报表制作

错误详细堆栈信息：com.kingdee.bos.BOSException: Error sql: select sib.fnumber as sNumber, mater.fnumber as mNumber,mater.fName_L2 mName,mater.fmodel as model,unit.fDisplayName_L2 as unitName,sie.FQty as fqty,sie.FUnitStandardCost as price,sie.FStandardCost as money,sie.fworknumberid as workNumber,sie.fcarnumber as carNumber into VTZ7WEUWUZ100BGL8F8UD5Y6N9XNVEO3INL from T_IM_SaleIssueBill sib left join T_IM_SaleIssueEntry sie on sib.fid=sie.fparentId left join T_BD_material mater on sie.fmaterialId=mater.fid left join t_org_baseUnit unit on sie.fbaseunitid=unit.fid

去掉sql中 into VTZ7WEUWUZ100BGL8F8UD5Y6N9XNVEO3INL 运行一次，发现sql没有问题.

经过仔细一看,发现sql语句中没有预编译的字段"字段=?",而我在不小心的时候copy了一段代码：
executeCreateAsSelectInto(sb.toString(), new SqlParams().setString(1, cuId), ctx);

改为 executeCreateAsSelectInto(sb.toString(), null, ctx); 就ok了.