table filter

B

billybean

Member

Licensed User

• Mar 2, 2009

• #1

how do i use a textbox.text for the data in filter
i have tried table1.filter("Front='Textbox1.text'") but it wont give any results

 

Cableguy

Expert

Licensed User

Longtime User

• Mar 3, 2009

• #2

billybean said:

how do i use a textbox.text for the data in filter
i have tried table1.filter("Front='Textbox1.text'") but it wont give any results

Click to expand...

This should be in Q&A....
try table1.filter("Front=" & textbox1.text)

 

Kintara

Member

Licensed User

Longtime User

• Jun 16, 2009

• #3

Filter with wildcard & textbox.text

Thanks for that answer. Now, how do I do a wildcard LIKE statement using a textbox.text as the search string? I have tried many combinations of single and double quote marks and the use of "&" in several places, but I cannot seem to hit on the right one!
Can you point me in the right direction?
Thanks

Kintara:sign0104:

 

specci48

Well-Known Member

Licensed User

Longtime User

• Jun 16, 2009

• #4

Hi Kintara,
here you are

B4X:

Table1.Filter("Column1 LIKE '" & TextBox1.Text & "'")

With this you can use the wildcard * as an input character in TextBox1.


specci48

 

Kintara

Member

Licensed User

Longtime User

• Jun 17, 2009

• #5

Many thanks

Thaks Speccy48
I get a bit stuck with the syntax on these things. Your answer was the perfect soloution!
Kintara