Table Filter with "and"

[hardy]

hi,


i would like to make a Filter like that but it doesnt work, Whats wrong?


Thank you

Hatmut


sr = "*" & Table1Textbox.Text & "*"
sr1 = "*" & Textbox30.Text & "*"

Table1.Filter("benennung LIKE '" & sr & "'" AND "benennung LIKE '" & sr1 & "'")

[Mr_Gee]

sr = "*" & Table1Textbox.Text & "*"
sr1 = "*" & Textbox30.Text & "*"

Table1.Filter("benennung LIKE '" & sr & "'" AND "benennung LIKE '" & sr1 & "'")

Do you have a textbox named "Table1Textbox"

Also I usually start with 1 filter item, and if it works add the 2nd

-= edit=-
tried it and i don't think the TABLE allows this since you are searching in the same column at the same time while the example is using a different column
as a workaround I would filter using one argument, copy that information to a temp table and search using the 2nd argument

Unless Erel has a solution :-)

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

[jeterry]

I tried this on a SQL database and it worked for me.

select * from inventory where description like '%Milk%' and description like '%GOAT%'

yielded one record with milk and goat in the description.

also tried it with OR and had all of the records with milk in the description and one goat.

To filter you must use the percent sign as shown

Hope this is what you are looking for

[Mr_Gee]

Originally Posted by jeterry

I tried this on a SQL database and it worked for me.

To be honest I would also go for SQL in this case.

[specci48]

Hi all,

the solution looks like this:

Table1.Filter("benennung LIKE '" & sr & "' AND benennung LIKE '" & sr1 & "'"

The AND has to be within the "".


specci48

[Mr_Gee]

Originally Posted by specci48

Hi all,

the solution looks like this:

Table1.Filter("benennung LIKE '" & sr & "' AND benennung LIKE '" & sr1 & "'"

The AND has to be within the "".
specci48

I can't believe I missed that one :-(

that did the trick, kudos to you

[specci48]

Originally Posted by Mr_Gee

I can't believe I missed that one :-(

I had to look twice, too...