Android Question Count number from SQLite

nazari.xxx · Sep 19, 2023

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

Erel · Sep 20, 2023

B4X:

Dim s As String = YourNumber
Log(s.Length)

aeric · Sep 20, 2023

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

imbault · Sep 20, 2023

aeric said:

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

Android Question Count number from SQLite

nazari.xxx

Member

Erel

B4X founder

aeric

Expert

imbault

Well-Known Member

Similar Threads

Android Question Count number from SQLite

nazari.xxx

Member

Erel

B4X founder

aeric

Expert

imbault

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency