Android Question Loading SQL data to custom views

[epiCode]

I have some very noob questions (have patience with me)

I have to display some rows of SQLite data to be displayed in CLV. (6 Columns - 2 of which are id and not to be displayed)

The data rows have to be arranged as shared in image with structure like this

Activity

CLV​

Panel1​

Lable1​

Lable2​

Lable3​

Lable4​

Then these panels should be added to CLV as list items.

So now my questions
1. Should I use CLV / xCLV / ULV or something else?
2. Should I use resultset, arrary, map, list (programatically) or invisible list in DesignerView to hold data returned from SQL query.
3. Is panel sufficient enough or I should use b4xpages (given that in future I might port it to b4i) ?
4. Should the panel which has to be added to any customlist be placed on same layout or different one
5. Will it help to use Dbutils or should I go with examples as given in b4xSqlite help booklets?
6. Is there an easier control which can be populated during the debug to check the result of SQL query ?

Thanks in advance

 

[Erel]

I recommend you to use xCustomListView.

You should use B4XPages for all new projects.

You can use B4XTable to see the data.

 

[epiCode]

I recommend you to use xCustomListView.

You should use B4XPages for all new projects.

You can use B4XTable to see the data.

Thanks Erel

Can you point me to some tutorial or example which populates xCLV from SQL ??

 

[Erel]

Here: https://www.b4x.com/android/forum/threads/b4x-b4xpages-sql-xclv-example.131888/