what is the update statement pattern in android SQLite to add a value the field?

Question

my code is as follows, but it seems not working.

public void update(int mixId, long startPos, int count) {
    SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
    db.execSQL("update downloadedFragement set downloadedLength=downloadedLength+? where mixId=? and startPos=?", 
            new Object[]{count, mixId, startPos});
}

score 0 · Answer 1 · edited May 23 '17 at 10:34

0

I had a similar problem and solved it by surrounding it with:

db.beginTransaction();
try {
    //do stuff, including execSQL()
    db.setTransactionSuccessful();
} finally {
    db.endTransaction();
}

See also https://stackoverflow.com/a/5575277/6027

edited May 23 '17 at 10:34

Community

1
1

answered Jul 31 '12 at 22:42

parkerfath

1,648
1
12
18

score 0 · Answer 2 · answered Jun 15 '11 at 01:13

0

From the doc on the execSQL() method:

Execute a single SQL statement that is NOT a SELECT/INSERT/UPDATE/DELETE.

You should use the update() method instead

answered Jun 15 '11 at 01:13

Noel

7,350
1
36
26

Yes, it is right to use the update() method, but it seems not easy to add a value to the original value using update method. – David Jun 15 '11 at 01:58
I'm not sure but you can attempt to use the method rawQuery() with the sql statement from your question. See this link http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#rawQuery(java.lang.String, java.lang.String[]). Otherwise you would need to do a query followed by an update. – Noel Jun 15 '11 at 02:20

what is the update statement pattern in android SQLite to add a value the field?

2 Answers2