ku = "dbo. MM_RAWENTRY_DT"
Sql = "select * from( '" & ku & "' )where( RAWENTRY_ID between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "')"
Rs.Open Sql, CN, 1, 3
这条语句有什么错误吗,总是返回空的结果。而下面这样就可以得到数据。是为什么?
Sql = "select * from dbo. MM_RAWENTRY_DT where( RAWENTRY_ID between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "')"
Rs.Open Sql, CN, 1, 3
Sql = "select * from( '" & ku & "' )where( RAWENTRY_ID between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "')"
Rs.Open Sql, CN, 1, 3
这条语句有什么错误吗,总是返回空的结果。而下面这样就可以得到数据。是为什么?
Sql = "select * from dbo. MM_RAWENTRY_DT where( RAWENTRY_ID between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "')"
Rs.Open Sql, CN, 1, 3
DTPicker1.Value 是日期控件?
如果是,这个条件子句也是乱套的