R RAJAN MBA Member Licensed User Longtime User Jul 18, 2014 #1 I would like to sum up a column in SQLite db. What is the equivalent of 'rawQuery' command?
eps Expert Licensed User Longtime User Jul 18, 2014 #2 This? http://www.sqlite.org/lang_aggfunc.html Upvote 0
K keirS Well-Known Member Licensed User Longtime User Jul 18, 2014 #3 Both ExecQuery and ExecQuery2 are raw queries. The SQL library doesn't use the Query method. Upvote 0
klaus Expert Licensed User Longtime User Jul 18, 2014 #4 Something like this: Sum = SQL1.ExecQuerySingleResult("SELECT total(" & ColumName & ") FROM " & DBTableName) Upvote 0
Something like this: Sum = SQL1.ExecQuerySingleResult("SELECT total(" & ColumName & ") FROM " & DBTableName)