急……请教各位……我这条语句有什么问题呢？
Adodc1.RecordSource = "select * from xcdjk where rq between ' " + Str(DTPicker1) + " ' and ' " + Str(DTPicker2) + " ') "
Adodc1.Refresh


老是说 ') '附近有错误！

refresh的方法‘Iadodc’失败！！



[解决办法]
Adodc1.RecordSource = "select * from xcdjk where rq between ' " + Str(DTPicker1) + " ' and ' " + Str(DTPicker2) + " ') "
Adodc1.Refresh
只有一半边的括符，还有一半边没见了。呵呵。。是不是啊。