我现在写了一个字段,如下
setTimeout(function(){
var area=contentPane.curLGP.getCellValue('D'+row);
var sql="SELECT city FROM Table_3 where LD= '"+area+"'";
var city=FR.remoteEvaluate('=sql("ae_bi","'+sql+'",1,1)'); contentPane.curLGP.setCellValue(4,row-1,city);
},300);
如果我要显示2个字段,需要查询2次吗,像下面这样?这会浪费资源吧
var sql="SELECT city,street FROM Table_3 where LD= '"+area+"'";
var city=FR.remoteEvaluate('=sql("ae_bi","'+sql+'",1,1)');
var street=FR.remoteEvaluate('=sql("ae_bi","'+sql+'",2,1)');