Android Question B4XTable Search each word not whole string?

[tsteward]

Can I use the search feature in B4XTable to split what is typed into the search box to filter and highlight each word.
At the moment if I type "Ford Wheel" that is exactly what it will search for.
Can I get it to search for "Ford" and or "Wheel"?

 

[Mahares]

Can I get it to search for "Ford" and or "Wheel"?

For this you can use CreateDataView:

Dim s1 As String ="Ford"
Dim s2 As String ="Wheel"
B4XTable1.CreateDataView($"c1 LIKE  '%${s1}%' OR c1  LIKE  '%${s2}%' "$)   'c0 is 1st col, c1 is 2nd, c2 is 3rd of in memory table

Can I use the search feature in B4XTable to split what is typed into the search box to filter and highlight each word.

For this you probably have to change the code for B4XTable class

 

[Magma]

Hi there..please check this

B4XTable Search using another search field

Hello all you Clever people out there I was wondering if it was possible to hide the search in the B4Xtable and use a field from a screen capture form? What I am trying to do is show a form and as the user captures the data a pop up starts to show matching entries

www.b4x.com

Of course this is sql direct to dB... but easily can change to b4xtable sql like mahares..