1、增加日期过滤条件select *from table1where field1 > to_date('${rq}','yyyy-MM-dd')2、在SQL中使用单选框参数${if($checkBox0," and T.status in(0, 1)","")}3、SQL中过滤非中文REGEXP_LIKE (T1.bm, '[\\u4e00-\\u9...

var a = FR.remoteEvaluate("SQL('db', 'truncate TABLE tableName',1)");if(a == 0){ FR.Msg.toast('表清空成功');}else{ FR.Msg.toast('表清空失败');}

转自：https://www.cnblogs.com/Williamls/p/10824055.html

contentPane.curLGP.getCellValue(1, 0);//获取文本框控件所在单元格的值 var yea=contentPane.curLGP.getCellValue("C1");var mon=contentPane.curLGP.getCellValue("E1");var tmp =String.format("SQL('hr', 'DELETE FROM ...

转自：https://help.finereport.com/doc-view-1557.html?tdsourcetag=s_pcqq_aiomsg