var T1 = this.options.form.getWidgetByName("t1").getValue(); var T2 = this.options.form.getWidgetByName("t2").getValue(); var T3 = this.options.form.getWidgetByName("t3").getValue(); var sql = "delete tag_supos WHERE tag_date >= '" + T1 + "' and tag_date <= '" + T2 + "' and substring(tag_name,7,10) like '%" + T3 + "%' "; alert(sql); var va = FR.remoteEvaluate('SQL("数据集名称","' + sql + '",1,1)'); alert('清除数据成功!'); location.reload(); |