sum

  1. Yafuhenk

    B4J Question SOLVED B4XTable How to get the sum of all selected (searched) values in a column

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

    B4J Question SOLVED B4XTable How to get the sum of all values in a column

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

    Android Question Select sum() and total() rounding

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