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});
}

Noel · Accepted Answer · 2011-06-15 01:13:57Z

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, 2011 at 1:13

Noel

7,4201 gold badge39 silver badges26 bronze badges

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

2 Comments

David Over a year ago

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.

Noel Over a year ago

I'm not sure but you can attempt to use the method rawQuery() with the sql statement from your question. See this link developer.android.com/reference/android/database/sqlite/…, java.lang.String[]). Otherwise you would need to do a query followed by an update.

Community · Accepted Answer · 2017-05-23 10:34:51Z

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, 2017 at 10:34

CommunityBot

11 silver badge

answered Jul 31, 2012 at 22:42

parkerfath

1,6611 gold badge12 silver badges22 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related