代码如下：var org_code = this.getValue()

alert(org_code);

/*alert(row+'|'+col);

row1 = contentPane.curLGP.getTDRow(contentPane.curLGP.currentTDCell);

col1 = contentPane.curLGP.getTDCol(contentPane.curLGP.currentTDCell);

alert(row1+'|'+col1);*/

//销售组织.select(ORG_ID,ORG_CODE = "9020")

//var sql = 'select JTBI_S_DATA_NEWINVENTORY_CS.nextval from dual'

var sql ="select ROUND(ORG_ID,0) AS ORG_ID from JTBI_SYS_ORGNINFO WHERE ORG_CODE='9020'";

//var rq=FR.remoteEvaluate("=ds1.select(ORG_ID,ORG_CODE=\"9020\")");

var rq = FR.remoteEvaluate("=SQL('BOE','"+sql+"',1,1)");

alert(rq);

contentPane.setCellValue(3,row-1,rq);

其中sql 为"select ROUND(ORG_ID,0) AS ORG_ID from JTBI_SYS_ORGNINFO"可以查询出数据，但是"select ROUND(ORG_ID,0) AS ORG_ID from JTBI_SYS_ORGNINFO WHERE ORG_CODE='9020'"查询不到对应的数据，但数据库中是存在这笔值的