Adding data from a SQLite column

Question

I'm, trying to add a credit score from multiple records of an SQLite table.

Each record has a column called credit score, I want to add them all together but I'm having trouble.

Here is the code:

String[] projection2 = { BorrowMeTable.COLUMN_CREDIT_SCORE };
Cursor databaseCursor2 = getContentResolver().query(uri, projection2,
        null, null, null);
int number  = 0;
if (databaseCursor2 != null) {
    databaseCursor2.moveToFirst();
    while (databaseCursor2.moveToNext()) { 
        number = number + databaseCursor2.getInt(
                databaseCursor2.getColumnIndexOrThrow(
                        BorrowMeTable.COLUMN_CREDIT_SCORE));
    }
}
Log.d("SCORE", Integer.toString(number));

The problem is the while statement, when it is in place it doesn't pull any data. When I remove it, it pulls the correct data but only from one record.

How many records are in the cursor?

Code-Apprentice
– Code-Apprentice

2013-03-10 00:52:07 +00:00
Commented Mar 10, 2013 at 0:52 — Code-Apprentice
– Code-Apprentice, Commented Mar 10, 2013 at 0:52

Moog · Accepted Answer · 2013-03-10 00:58:33Z

1

Use the sum funstion in SQLite

Cursor cursor = sqliteDatabase2.rawQuery(
    "SELECT SUM(COLUMN_CREDIT_SCORE) FROM BorrowMeTable", null);

You can URI match this in your ContentProvider as a different URI

Then simply get the scalar value:

if(cursor.moveToFirst()) {
    return cursor.getInt(0);

answered Mar 10, 2013 at 0:58

Moog

10.2k2 gold badges42 silver badges68 bronze badges

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

Comments

AwadKab · Accepted Answer · 2013-03-10 03:09:55Z

0

Use do->while to start from first record

  do{
    number = number + databaseCursor2.getInt(
            databaseCursor2.getColumnIndexOrThrow(
                    BorrowMeTable.COLUMN_CREDIT_SCORE));
}while (databaseCursor2.moveToNext());

answered Mar 10, 2013 at 3:09

AwadKab

3,0642 gold badges19 silver badges17 bronze badges

Collectives™ on Stack Overflow

Adding data from a SQLite column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related