B4J Question SQLite math functions

RobertK · Apr 10, 2022

Would it be possible to enable SQLite math functions in B4J or B4A or both? I am currently most interested in the modulo function but any and all of the following would be useful at some stage.

https://www.sqlite.org/lang_mathfunc.html

Thanks in advance for any suggestions.

LucaMs · Apr 11, 2022

I'm afraid that the same answer to this one of mine applies to this question of yours:
https://www.b4x.com/android/forum/threads/sqlite-soundex.139140/

MicroDrie · Apr 11, 2022

Tested in B4J, not sure if really needed but i have tested it with:

B4J Main module:

#AdditionalJar: sqlite-jdbc-3.36.0

This gives a result for modulo:

SQLite Modulo:

    Dim ModX As Int = 153
    Dim ModY As Int = 4
    
    Dim ModXstr As String = "153"
    Dim ModYstr As String = "4"
    
    Dim Result As String = SQL1.ExecQuerySingleResult($"SELECT ${ModX}%${ModY};"$)
    Log($"1. Result MOD(Xint%Yint) = ${Result}"$)

    Dim Result As String = SQL1.ExecQuerySingleResult($"SELECT ${ModX},${ModY};"$)
    Log($"2. Result MOD(Xint,Yint) = ${Result}"$)

    Result = SQL1.ExecQuerySingleResult($"SELECT ${ModX},${ModY};"$)
    Log($"3. Result MOD(Xint,Yint) = ${Result}"$)

    Result = SQL1.ExecQuerySingleResult($"SELECT ${ModXstr},${ModYstr};"$)
    Log($"4. Result MOD(Xstr,Ystr) = ${Result}"$)

    Dim ResultInt As Int = SQL1.ExecQuerySingleResult($"SELECT ${ModX},${ModY};"$)
    Log($"5. Result MOD(Xint,Yint) = ${ResultInt}"$)

Your lucky ?, only the SELECT MOD(X%Y) shorthand query can be used in SQLite.

RobertK · Apr 12, 2022

Thank you, the % operator works perfectly and is just what I was looking for. Really appreciate your help.

B4J Question SQLite math functions

RobertK

Member

LucaMs

Expert

MicroDrie

Well-Known Member

RobertK

Member

Similar Threads

B4J Question SQLite math functions

RobertK

Member

LucaMs

Expert

MicroDrie

Well-Known Member

RobertK

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency