View Single Post
  #2 (permalink)  
Old 06-23-2008, 11:07 AM
Mr_Gee Mr_Gee is offline
Basic4ppc Veteran
 
Join Date: Feb 2008
Location: Hilversum, The Netherlands
Posts: 237
Awards Showcase
Beta Tester 
Total Awards: 1
Default

Quote:

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 :-)




Code:
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

Last edited by Mr_Gee : 06-23-2008 at 11:22 AM.
Reply With Quote