s_sql="SELECT jzhm,qfy,xj,sffs,sfrq,yhzl FROM "+ s_table +" where sffs = " + "1" + " and sfrq>=date('"+s_time+"')" + " and jzhm >'4000000' and jzhm <'5000000'" + " ORDER BY sfrq DESC"
报函数参数个数不对,而且不能替换表了?jhc请指教!
s_sql="select jzhm,qfy,sfrq from "+ qfk1 +" where sffs = " + "1" +" and sfrq>=date('"+s_date+"') + " order by sfrq desc"
dw_1.settransobject(s_sql)
and 之前应该有空格
s_date 应该是字符串变量吧,转换成date型放进s_sql可能会错,最好把转换放进SQL语句里