VB+Access模糊查询like的问题,在线等
各位好!
今天碰到一个奇怪的问题:
我用Access 2003中的查询工具查询下面语句:
select * From FileDetail where Receiver_no Like '*77*'
能查到相关记录.记录有几条.
但我通过VB代码如下:
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
str = "select * From FileDetail where Receiver_no Like '*77*'"
rs.Open str, cn, adOpenDynamic, adLockOptimistic, adCmdText
If rs.RecordCount > 0 Then '这里的rs.recordcount=0,真是奇怪?
Call FillGridRecord(rs)
End If
高手能否指点一下原因.本是一个简单的问题,把我搞糊涂了.

[解决办法]
str = "select * from FileDetail where Receiver_no like '%" & Trim(Text1.Text) & "%'"

str = "select * from FileDetail where Receiver_no like '%" & "77" & "%'"
[解决办法]