Question

Visual Basic6.0中ACCESS模糊查询检索失败原因分析

'Dim sql As String
'If chkFilter(0) And chkFilter(1) And Not chkFilter(2) Then
' lstTitles.Clear
' With g_rsItem
' sql = "SELECT Title From tb_Item " & _
' "WHERE tb_Item.Title like '*_web' or tb_Item.Title like '*_csw'" & _
' " ORDER BY Frequency" & " DESC"
'' .CursorLocation = adUseClient
' .Open sql, g_cn, adOpenKeyset, adLockOptimistic
' If .RecordCount > 0 Then
' Do Until .EOF
' lstTitles.AddItem .Fields("Title")
' .MoveNext
' Loop
' End If
' .Close
' End With
'End If
调试时.RecordCount=0，求解。

Answer 1

sql = "SELECT Title From tb_Item " & _
' "WHERE tb_Item.Title like '*_web*' or tb_Item.Title like '*_csw*'" & _
' " ORDER BY Frequency" & " DESC"
前后均加*试试。

追问

不行

Answer 2

access yinqing mei lianhao