前台用PB,数据库用access
代码中sql语句的where字句如何判断?
s_sql="SELECT TBLCP.BLDJ, TBLCP.JGDW, TBLCP.KSRQ, TBLCP.JSRQ ,TBLCP.BLGS FROM TBLCP "
s_sql=s_sql + "WHERE KSRQ <= ts { " + d_date + "} and JSRQ >=ts { " + d_date + "}
dw_6.setsqlselect(s_sql)
dw_6.retrieve()
以上语句执行不成功,请问问题出在哪?
s_sql=s_sql + "WHERE KSRQ <= #" + d_date + "# and JSRQ >=#" + d_date + "#"
试试