B4J Question Search field on a Tableview

Peter Lewis · May 10, 2017

Hi All

I am looking for a way to be able to search my SQLite data and display the results in a Tableview.

I am from a Clarion Background and we had the option to place a box next to the table and as we started typing in what we were looking for it would automatically filter out records depending on what was typed in, even if it was not complete.

Does B4J have something like this ?

I have searched around the Forums but could not find anything, maybe my search wording was wrong.

Thank you

Peter

Erel · May 11, 2017

There are all kinds of ways to implement it.

I would have started with the direct approach. Handle the TextChanged event. Check if the text length is larger than 2 or 3 and create a SQL query with LIKE to filter based on the prefix.

Example is attached.

The source for the CSV file with the data: http://blog.plsoucy.com/2012/04/iso-3166-country-code-list-csv-sql/

Erel · May 11, 2017

If you want it to match all occurrences instead of prefix only then change the filter value to: "%" & New & "%"

Peter Lewis · May 11, 2017

Erel said:
If you want it to match all occurrences instead of prefix only then change the filter value to: "%" & New & "%"

Thank you Erel. You are the Master !!!

Erel · May 11, 2017

And a modified version that highlights the matches:

It uses TextFlow (included in the example): https://www.b4x.com/android/forum/threads/61237/#content

Peter Lewis · May 11, 2017

Erel said:
There are all kinds of ways to implement it.

I would have started with the direct approach. Handle the TextChanged event. Check if the text length is larger than 2 or 3 and create a SQL query with LIKE to filter based on the prefix.

Example is attached.

The source for the CSV file with the data: http://blog.plsoucy.com/2012/04/iso-3166-country-code-list-csv-sql/

I updated and tested with one of my tables and it works exactly how I wanted it to, I am surprised I did not find it searching the forums. How should I have searched for it ? I have having to ask questions all the time.

There was only one issue with this and if I put the following lines of code as you suggested, then the Tableview problem I had earlier by not displaying the correct headers and column widths does not work. So I took these 2 lines and and it worked again.

Are these lines Important ?

B4X:

'    SearchField_TextChanged("", "")
'    SearchField.RequestFocus

Thank You

inakigarm · May 11, 2017

The first line calls the SearchField (textfield view) Textchanged Event with params "" to fill the tableview with all the records from DB

B4X:

If New = "" Then
        DBUtils.ExecuteTableView(sql, "SELECT name, code FROM countries", Null, 100, tableview1)

The second calls the focus on Searchfield (textfield) view.

Maybe if you introduce a delay before calling this lines (with Callsubdelayed or the new sleep function) the tableview1 redraws correctly (difficult without seeing the code)

Peter Lewis · May 11, 2017

inakigarm said:
The first line calls the SearchField (textfield view) Textchanged Event with params "" to fill the tableview with all the records from DB

B4X:

If New = "" Then DBUtils.ExecuteTableView(sql, "SELECT name, code FROM countries", Null, 100, tableview1)

The second calls the focus on Searchfield (textfield) view.

Maybe if you introduce a delay before calling this lines (with Callsubdelayed or the new sleep function) the tableview1 redraws correctly (difficult without seeing the code)

I found out how to solve it. Initially I had to move all the code that relates to the table ie names and widths to after the DBUTILS commands. Not that DBUTILS command are inside another sub , I have to do it there as well and it works.

Thank you for responding

Erel · May 11, 2017

Peter Lewis said:
I am surprised I did not find it searching the forums. How should I have searched for it ?

It was only created today.
It now returns as the second search result: https://www.b4x.com/android/forum/pages/results/?query=tableview+search+b4j

B4J Question Search field on a Tableview

Peter Lewis

Active Member

Erel

B4X founder

Attachments

Erel

B4X founder

Peter Lewis

Active Member

Erel

B4X founder

Attachments

Peter Lewis

Active Member

inakigarm

Well-Known Member

Peter Lewis

Active Member

Erel

B4X founder

Similar Threads

B4J Question Search field on a Tableview

Active Member

B4X founder

Attachments

B4X founder

Active Member

B4X founder

Attachments

Active Member

Well-Known Member

Active Member

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency