In the meantime I learnt that you can get the sum of a column in the B4XTable with
Dim total As Double = B4XTable1.sql1.ExecQuerySingleResult($"SELECT sum(${Column.SQLID}) FROM data"$)
But what if the user searched for a certain text. Do I have to work with the WHERE statement in the query or is...
Hello friends
I'm in trouble I'd like someone to help me. I'm running a sql query with select sum () and select total () in the sqlite database and the result is rounding to a smaller one.
code:
conect.db.BeginTransaction
rs = conect.db.ExecQuery("Select total(Valor) as TotalTitulos, " & _...