SQLite Update Query add 1 to value

Question

I am struggling with using the update function of Sqlite in my android app. I am simply trying to add 1 to the value that already exists in a row.

This is what I currently have:

 public void updateItemQty(int SKU) {
        SQLiteDatabase db = getWritableDatabase();
        String p[] = new String[]{String.valueOf(SKU)};
        ContentValues args = new ContentValues();
        args.put(Keys.Key_SENTQTY, Keys.Key_SENTQTY + 1);
        try {
            db.update(Keys.Key_CARTONITEMTABLE, args, Keys.Key_SKU + " = ? AND " + Keys.Key_STATUS + " = 0 ", p);
        } catch (SQLiteException e) {
            e.printStackTrace();
        }

        db.close();
    }

This issue being that instead of adding 1 to my key.KEY_SENTQTY, it just enters sent_qty1 into the table! How do I achieve what I am after?

Thanks

db.rawQuery with standard UPDATE code for such cases(update table set col1 = col1 + 1 where col2=somevalue) or read value first add 1 in java code and then update with new value using db.update (for safe you should use transaction) ... there is no way to increment/add value directly using db.update — Selvin
– Selvin, Commented Jul 24, 2014 at 12:22

njzk2 · Accepted Answer · 2014-07-24 13:08:28Z

1

technically, you could set sent_qty to sent_qty + 1, but not using contentValues, as these are escaped thoroughly.

Using execSQL, you can do:

db.execSQL("update " + Keys.Key_CARTONITEMTABLE 
         + " set " + Keys.Key_SENTQTY + " = " + Keys.Key_SENTQTY + " + 1 where " 
         + Keys.Key_SKU + " = " + SKU + " and " + Keys.Key_STATUS + " = 0");

edited Jul 24, 2014 at 13:08

answered Jul 24, 2014 at 12:45

njzk2

39.4k7 gold badges72 silver badges111 bronze badges

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

Comments

Huy Tran · Accepted Answer · 2014-07-24 12:26:11Z

0

It's because Keys.KEY_SENTQTY is a String. How are you supposed to add an int to a String?

answered Jul 24, 2014 at 12:26

Huy Tran

1981 silver badge8 bronze badges

1 Comment

dave Over a year ago

Badly explained but kind of right, the reason being that ContentValues are set pre-query, so there is no value to Keys.KEY_SENTQTY

dave · Accepted Answer · 2014-07-24 12:35:04Z

0

After a bit of research and be pointed in the right direction by @Selvin, this is not possible as ContentValues are set pre-query, so you don't have the value of a row to add too.

My Assumption was that this was executed when the query was run, which was incorrect.

answered Jul 24, 2014 at 12:35

dave

1,4301 gold badge16 silver badges43 bronze badges

Collectives™ on Stack Overflow

SQLite Update Query add 1 to value

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related