vb access MySQL = "select * from 监理备案 Where [竣工日期] > " & Date & " Order By [竣工日期] DESC"竣工日期 字段是日期类型日期格式是2009-1-12得的结果去不对??5555555555555555555555555555大虾,大虾。
VB没用过 MySQL = "select * from 监理备案 Where [竣工日期] > " & Date & " Order By [竣工日期] DESC"感觉应该是这句里面" & Date & "赋值出问题了。 楼主提取下,实际运行过程中的MySQL,看看是否与要求的格式一致吧。
MySQL = "select * from 监理备案 Where [竣工日期] > " & Date & " Order By [竣工日期] DESC" ??MySQL = "select * from 监理备案 Where [竣工日期] > #" & Date & "# Order By [竣工日期] DESC" ??
MySQL = "select * from 监理备案 Where [竣工日期] > " & Date() & " Order By [竣工日期] DESC" ??
如果在access里的话,你可以试一下用#将日期定义起来,如 select * from 监理备案 Where [竣工日期] > #" & Date & "# Order By [竣工日期] DESC 你的date变量正确吗?如果是要当前时间的话,应该是now() select * from 监理备案 Where [竣工日期] > #" & now() & "# Order By [竣工日期] DESC
感谢山中客正确答案: MySQL = "select * from 监理备案 Where [竣工日期] > #" & Date & "# Order By [竣工日期] DESC" 马上结账!
VB没用过
MySQL = "select * from 监理备案 Where [竣工日期] > " & Date & " Order By [竣工日期] DESC"感觉应该是这句里面" & Date & "赋值出问题了。
楼主提取下,实际运行过程中的MySQL,看看是否与要求的格式一致吧。
??MySQL = "select * from 监理备案 Where [竣工日期] > #" & Date & "# Order By [竣工日期] DESC"
??
??
select * from 监理备案 Where [竣工日期] > #" & Date & "# Order By [竣工日期] DESC
你的date变量正确吗?如果是要当前时间的话,应该是now()
select * from 监理备案 Where [竣工日期] > #" & now() & "# Order By [竣工日期] DESC
MySQL = "select * from 监理备案 Where [竣工日期] > #" & Date & "# Order By [竣工日期] DESC" 马上结账!