编一程序要查找一定时间内的记录,在VB里运行出错,提示"标准表达式中数据类型不匹配"
adoprimaryrs.Open "select * from 修复量台帐 where gq='1' and (xfsj between '2005-12-1' and '2005-12-9') Order by id"而把在SQL SERVER ENTERPRISE MANAGER下执行
"select * from 修复量台帐 where gq='1' and (xfsj between '2005-12-1' and '2005-12-9') Order by id"
却很正常为什么会有这种情况啊,有没办法解决?
adoprimaryrs.Open "select * from 修复量台帐 where gq='1' and (xfsj between '2005-12-1' and '2005-12-9') Order by id"而把在SQL SERVER ENTERPRISE MANAGER下执行
"select * from 修复量台帐 where gq='1' and (xfsj between '2005-12-1' and '2005-12-9') Order by id"
却很正常为什么会有这种情况啊,有没办法解决?
或者你把sql语句换成简单的如"select * from 修复量台帐"再试试。逐步找出原因。
可能是两班人做的开发,互相没通气吧。-_-