zdqsosmart(提问者) 回复 Kerydia试了下SQL()可以执行没有传参的sql语句,如果带上where条件就查不出值:1、select ROUND(ORG_ID,0) AS ORG_ID from JTBI_SYS_ORGNINFO可查询出值;2、\"select ROUND(ORG_ID,0) AS ORG_ID from JTBI_SYS_ORGNINFO WHERE ORG_CODE=\'9020\'\"查不出数据,但这条在数据库中是可以查到值的
Kerydia 回复 zdqsosmart(提问者)=SQL(\"FRDemo\", \"select ROUND(ORG_ID,0) AS ORG_ID from JTBI_SYS_ORGNINFO WHERE ORG_CODE=\\\'9020\\\'\", 1,1) sql语句里的单引号需要加\\
=SQL(\"FRDemo\", \"select ROUND(ORG_ID,0) AS ORG_ID from JTBI_SYS_ORGNINFO WHERE ORG_CODE=\\\'\"+参数+\"\\\'\", 1,1) sql语句里的单引号需要加\\