my command to sum up the price values isnt working

Question

public ArrayList calculateTotal() {

    SQLiteDatabase db = this.getWritableDatabase();
    ArrayList<Integer> array_list2 = new ArrayList<Integer>();

    Cursor cursor1 = db.rawQuery(
            "SELECT SUM(cost) FROM expense", null);
    if (cursor1.moveToFirst()) {
        columntotal = cursor1.getFloat(0);
    }
    cursor1.close();
    db.rawQuery("INSERT INTO total VALUES(columntotal)", null);

I'm unable to sum up the cost and display in android studio....

What isn't working? Do you get an exception? – doerig Jan 04 '17 at 16:16 — doerig, Jan 04 '17 at 16:16

score 0 · Answer 1 · edited May 23 '17 at 12:08

0

Your insert command should be something like below:

"INSERT INTO total VALUES("+columntotal+")"

Its better to use PreparadStatement approach

edited May 23 '17 at 12:08

Community

1
1

answered Jan 04 '17 at 15:47

kosa

63,683
12
118
157

my command to sum up the price values isnt working

1 Answers1