大家帮忙看看select max(freq) from gpsdata where ('num=&start_num_of_this_test&')
Set rsty = cnn.Execute("select max(freq) from gpsdata where ('num=&start_num_of_this_test&')")
大家帮忙看看select max(freq) from gpsdata where ('num=&start_num_of_this_test&')
这个SQL语句怎么了,
num是表中的字段,start_num_of_this_test是int型的,
我想写这样where (num='&start_num_of_this_test&'),也不对啊
[最优解释]
"select max(freq) from gpsdata where num = " & start_num_of_this_test
[其他解释]
谢谢了,下午弄好了
我一直以为是这样的"select max(freq) from gpsdata where num = " & start_num_of_this_test &""
呵呵