Question

vb中如何写查询语句

s 和 ss，sover都为string
TmpSource = "SELECT l.Send_datetime as 发送时间,l.MsgContent as 短信内容" _
+ " FROM SendHistory l WHERE Send_datetime like +" _
+ " '" + s + "%'" And Send_datetime > ss And Send_datetime < sover
现在编译的时候说类型不匹配 是不是like后的换行符引起的错误啊

Answer 1

TmpSource = "SELECT Send_datetime as 发送时间,MsgContent as 短信内容 FROM SendHistory WHERE Send_datetime like '%" & s & "%' And Send_datetime > #" & ss & "# And Send_datetime < #" & sover & "#"