hello i make an searchbox they search in my complete list as the input string but my problem is.. if i input anythink just the first letter was used by the search... here is the code:
Sub Searchbox_TextChanged (Old As String, New As String)
Cursor = ST.ExecQuery("Select DISTINCT * FROM database WHERE music or artist like '%" & Searchbox.Text & "%' ORDER BY 'Music';")
lvNames.Clear
For i = 0 To Cursor.RowCount - 1
Cursor.Position = i
lvNames.AddSingleLine(Cursor.GetString(db))
Next
Cursor.Close
End Sub
how can i make it that all search strings be considered?
Sub Searchbox_TextChanged (Old As String, New As String)
Cursor = ST.ExecQuery("Select DISTINCT * FROM database WHERE music or artist like '%" & Searchbox.Text & "%' ORDER BY 'Music';")
lvNames.Clear
For i = 0 To Cursor.RowCount - 1
Cursor.Position = i
lvNames.AddSingleLine(Cursor.GetString(db))
Next
Cursor.Close
End Sub
how can i make it that all search strings be considered?