Yafuhenk Active Member Licensed User Apr 1, 2020 #1 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
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
Erel Administrator Staff member Licensed User Apr 1, 2020 #2 B4X: Dim total As Double = B4XTable1.sql1.ExecQuerySingleResult($"SELECT sum(${numberColumn.SQLID}) FROM data"$) Log(total)
B4X: Dim total As Double = B4XTable1.sql1.ExecQuerySingleResult($"SELECT sum(${numberColumn.SQLID}) FROM data"$) Log(total)