91比较大小的摆放

最新推荐文章于 2021-05-27 19:55:00 发布

「已注销」

最新推荐文章于 2021-05-27 19:55:00 发布

阅读量166

点赞数

本文链接：https://blog.youkuaiyun.com/weixin_42983731/article/details/83302342

版权

<>和=在链接数据库是有顺序的如

正确代码
txtsql = “select * from recharge_info where date >=’” & DTP1.Value & “'and date <= '” & DTP2.Value & “’”
Set mrc = ExecuteSQL(txtsql, msgtext)

错误代码

txtsql = "select * from recharge_info where date =>'" & DTP1.Value & "'and date =< '" & DTP2.Value & "'"
            Set mrc = ExecuteSQL(txtsql, msgtext)