Android Tutorial [B4X] B4XTable - Load data from SQL database

B4XTable.SetData expects a List where each entry in the list is an array of objects with the data of a single row.

The data can come from any source you like.

Example of loading the data from a SQL database:

B4XTable1.AddColumn("Customer Id", B4XTable1.COLUMN_TYPE_NUMBERS)
   B4XTable1.AddColumn("Name", B4XTable1.COLUMN_TYPE_TEXT)
   B4XTable1.AddColumn("Company", B4XTable1.COLUMN_TYPE_TEXT)
   B4XTable1.AddColumn("Address", B4XTable1.COLUMN_TYPE_TEXT)

   Dim Data As List
   Data.Initialize
   Dim rs As ResultSet = sql.ExecQuery("SELECT CustomerId, FirstName, LastName, Company, Address FROM customers")
   Do While rs.NextRow
       Dim row(4) As Object
       row(0) = rs.GetDouble("CustomerId")
       row(1) = rs.GetString("FirstName") & " " & rs.GetString("LastName")
       row(2) = rs.GetString("Company")
       'Some of the values are Null. We need to convert them to empty strings:
       If row(2) = Null Then row(2) = ""
       row(3) = rs.GetString("Address")
       Data.Add(row)
   Loop
   rs.Close
   B4XTable1.SetData(Data)

Step #1: add the columns.
Step #2: fill the Data list with the data coming from the SQL db.
Step #3: call B4XTable.SetData.

B4A project is attached.

Database source: http://www.sqlitetutorial.net/sqlite-sample-database/

 

[Omar Moreno]

Greetings.

The library is very good.
You could show the code to load a column with SQLITE BLOB type values.

Thank you.

 

[Erel]

Getting the values out of the database is very simple. If you want to show images then follow this tutorial: [B4X] B4XTable with custom cells layout

 

[harinder]

Do we have to define column headers for b4xtable separately? Can b4xtable pick up entire db with headers as used to be the case in Flexitable----"table1.LoadSQLiteDB(SQL1, Query, True)". in which case headers were not separately defined for Table1? thnx

 

[Erel]

Do we have to define column headers for b4xtable separately?

Yes.

You can extend this code to get the list of columns and their types and add them automatically.