Android Question B4x table Create data view with max and min value in

G

GJREDITOR

Member
I need to show the maximum and minimum marks in b4xtable. I get the data from Google sheet and I am displaying it in b4xtable. I tried using the below code to get maximum and minimum data . Obviously the code is wrong as I get the error : "java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: MAXc3)". Could someone guide me as to how to get maximum and minimum value and either highlight it or create a dataview?
Get maximum in 'NEET Mark Column': 
'NumberColumn = B4XTable1.AddColumn("NEET MARKS", B4XTable1.COLUMN_TYPE_NUMBERS)'
B4XTable1.CreateDataView($"MAX${NumberColumn.SQLID}"$)
 
Solution
M
You need to first extract the max of the column in question and then use it in the CreateDataview: In one line:
B4X: 
B4XTable1.CreateDataView($"${NumberColumn.SQLID} = (SELECT max(c0) FROM data)"$)  'better way
or in 2 lines below:
B4X: 
Dim x As Int =B4XTable1.sql1.ExecQuerySingleResult($"SELECT max(c0) FROM data"$)  'c0 is 1st col, c1 is 2nd
        B4XTable1.CreateDataView($"${NumberColumn.SQLID} = ${x}"$)
If NumberColumn is 1st use c0 with max, if 3rd use c2, etc. If this does not solve it for you, export your project to forum.
Sort by date Sort by votes
M

Mahares

Expert
Licensed User
Longtime User
You need to first extract the max of the column in question and then use it in the CreateDataview: In one line:
B4X: 
B4XTable1.CreateDataView($"${NumberColumn.SQLID} = (SELECT max(c0) FROM data)"$)  'better way
or in 2 lines below:
B4X: 
Dim x As Int =B4XTable1.sql1.ExecQuerySingleResult($"SELECT max(c0) FROM data"$)  'c0 is 1st col, c1 is 2nd
        B4XTable1.CreateDataView($"${NumberColumn.SQLID} = ${x}"$)
If NumberColumn is 1st use c0 with max, if 3rd use c2, etc. If this does not solve it for you, export your project to forum.
 
Upvote 2
Solution
G

GJREDITOR

Member
Thank you, Mahares. Works perfectly. I assume the 'data' is the db name created by B4Xtable library internally?
 
Upvote 0
You must log in or register to reply here.

Similar Threads

M
  • Question
Android Question B4XTable-Setup Table with Fewer Columns Using QueryBuilder Without Redefining Columns
Replies
4
Views
588
Erel
  • Question
Android Question B4XTable Autofit Column Width
Replies
1
Views
2K
Mahares
M
  • Article
Android Code Snippet RoundSlider Min/Max Values
Replies
1
Views
2K
MbedAndroid
M
M
  • Question
Android Question How to insert datamap values into a table
Replies
1
Views
687
Erel
  • Locked
  • Article
Android Code Snippet [B4X] B4XTable - Resize columns based on content
2
Replies
29
Views
14K
beelze69
B
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…