Sql Count function

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 22, 2011

• #2

SQL syntax is not special in Basic4android. It is processed by the SQLite engine.
If you are using DBUtils you can use DBUtils.ExecuteListView. The query should be something like:

B4X:

SELECT category, count(category) FROM Categories GROUP BY category

 

Upvote 0

C

cnicolapc

Active Member

Licensed User

Longtime User

• Oct 22, 2011

• #3

Thank you Erel.

 

Upvote 0

C

cnicolapc

Active Member

Licensed User

Longtime User

• Oct 22, 2011

• #4

Hi,
If you do not ask too much, I have a practical example on how to fill the listview with the category name and the record count in it? is probably simple but I can not figure it out.
thanks in advance
Nicola

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 22, 2011

• #5

See DBUtils.ExecuteListView: DBUtils - Android databases are now simple!

 

Upvote 0