B4J Question SQLite math functions

[RobertK]

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]

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]

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

#AdditionalJar: sqlite-jdbc-3.36.0

This gives a result for 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]

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