Android Question Count number from SQLite

nazari.xxx

Member
Hello.
How can I count number from from database?

For example
I get 59632485 from SQLite then I can show count 8

Or
59632485 -»8
 

aeric

Expert
Licensed User
Longtime User
Get length of a value using SQL query?

B4X:
Private Sub Query
    Dim RS As ResultSet = SQL1.ExecQuery("SELECT Length(59632485)")
    Do While RS.NextRow
        Log(RS.GetInt2(0))
    Loop
    RS.Close
End Sub
 
Upvote 0

imbault

Well-Known Member
Licensed User
Longtime User
Get length of a value using SQL query?

B4X:
Private Sub Query
    Dim RS As ResultSet = SQL1.ExecQuery("SELECT Length(59632485)")
    Do While RS.NextRow
        Log(RS.GetInt2(0))
    Loop
    RS.Close
End Sub

Hello, that statement should work as well
 
Upvote 0
Top