sr = "*" & Table1Textbox.Text & "*"
sr1 = "*" & Textbox30.Text & "*"
Table1.Filter("benennung LIKE '" & sr & "'" AND "benennung LIKE '" & sr1 & "'")
Sub App_Start
Form1.Show
Table1.AddCol(cString,"benennung",80,False)
i = 0
Do Until i = 60
Table1.AddRow("Test"&i)
i = i + 1
Loop
End Sub
Sub Button1_Click
'sr = "*" & Table1Textbox.Text & "*"
'sr1 = "*" & Textbox30.Text & "*"
'Table1.Filter("benennung LIKE '" & sr & "'" AND "benennung LIKE '" & sr1 & "'")
Table1.Filter("benennung LIKE 5" AND "benennung LIKE 9")
End Sub
I tried this on a SQL database and it worked for me.
Hi all,
the solution looks like this:The AND has to be within the "".B4X:Table1.Filter("benennung LIKE '" & sr & "' AND benennung LIKE '" & sr1 & "'"
specci48
I had to look twice, too...I can't believe I missed that one :-(