大家帮忙看看select max(freq) from gpsdata where (num&start_num_of_this_test&)Set rsty cnn.Exec
大家帮忙看看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