SUM sqlite column values (android)

Question

I need help with summing all the values in one of the columns(KEY_CONTENT6) in my database(MYDATABASE_TABLE). I keep having force close issues, somebody tell me what I'm doing wrong!

Heres my code:

public Cursor sumAll(){

 float columntotal = 0;
 Cursor cursor1 = sqLiteDatabase.rawQuery(
     "SELECT SUM("+Float.valueOf(KEY_CONTENT6)+") FROM MYDATABASE_TABLE", null);
       if(cursor1.moveToFirst()) {
         columntotal = cursor1.getFloat(0);
     }
   cursor1.close();

 String  sumtotal = Float.toString((float)columntotal);           

  return cursor1;

 }

The column KEY_CONTENT6 is a string for various reasons which is why I used Float.valueOf() but I'm guessing that's where my problem is.

RasTheDestroyer · Accepted Answer · 2012-02-25 18:56:03Z

1

You're closing the cursor then returning it. You probably want to return the column total or sum total, not the cursor

answered Feb 25, 2012 at 18:56

RasTheDestroyer

1,76116 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SUM sqlite column values (android)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related