Please help...

I have a column that contains a list of numeric values. Is there any way so that I can add all those values up and display the total in a TextView, and how would I do that?

Thanks!

Do a rawQuery() using:
select sum(myColumn) from myTable

nmc wrote:Do a rawQuery() using:
select sum(myColumn) from myTable

Thanks for the reply, but I'm not familiar with SQLite.. I did some research and I ended up coming up with this code..



is that correct?

Well, you have to fetch the result (its not in your code), but the query will do the trick, yes.

...are you sure you have named your table "Table"?
You shouldnt do that since its a reserved token

nmc wrote:Well, you have to fetch the result (its not in your code), but the query will do the trick, yes.

...are you sure you have named your table "Table"?
You shouldnt do that since its a reserved token

the table name is actually dbTable. i figured that i needed to do something else because when calling getTotatl(); catlog shows that no column name was found.. again im not quite sure on how to fetch the results.

the table name is actually dbTable. i figured that i needed to do something else because when calling getTotatl(); catlog shows that no column name was found..

...but you got this running now?

again im not quite sure on how to fetch the results

How do you get results when fetching direct data, e.g. for displaying database contents?
Use cursor.getInt(0), since the column will not match any column-name used in your table, but will something like "SUM(COL_ITEM2)".

If your query is "SELECT SUM(COL_ITEM2) as sum FROM dbTable", then you can fetch the result using "sum" as findColumn() Parameter (not sure if the function name really is findColumn, but you get the idea)