sum

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...

Does anyone know how I can get the sum of all values in a B4XTable column, so not only the ones that are visible? Thanks

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, " & _...