怎样把自己定义的变量作为数据库查询的条件？

[linlindaidai]

DIM searchdate as DATE

我看到别的程序以下语句可以通过，而我这里就不行，不知道为什么？
str=
"select * from table1
where table1.date =# " & searchdate & " # "

如果要把自己定义的变量作为查询条件以上语法正确吗？还是用其它的办法？

[a97191]

数据库不同，如果是ACCESS应该可以通过，sql server
str=
"select * from table1
where table1.date =' " & searchdate & " ' "

[bbhere]

str="select * from table1 where table1.date =' " & searchdate & " ' "