Android SQLite Update not working

Question

I am trying to update one column for any number of rows.

Here is the function:

public void setAwardsSyncComplete(String[] ids) {

    String inArray = StringUtils.separateCommas(ids);
    db.beginTransaction();

    try {
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_SYNCED, true);

        int rowsAffected = db.update(TABLE, contentValues, COL_ID + " IN (" + inArray + ")", null);

    } catch (Exception e) {

        DebugLog.e("Error in transaction", e.toString());
    } finally {

        db.endTransaction();
    }
}

What is strange is that the rowsAffected returns correctly (i.e. rowsAffected > 0), but the column values remain null.

Am I overlooking something very simple here?

Thanks.

Phil Lello · Accepted Answer · 2011-04-07 02:29:31Z

8

As you're using transactions, you need to call db.setTransactionSuccessful(); at the end of the try clause. Without this, the update gets rolled back.

See SQLiteDatabase.beginTransaction

Hope this helps,

Phil Lello

answered Apr 7, 2011 at 2:29

Phil Lello

8,6592 gold badges27 silver badges36 bronze badges

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

Comments

Joseph Earl · Accepted Answer · 2011-04-07 02:27:23Z

2

You need to call db.setTransactionSuccussful() after db.update otherwise any changes will be rolled back when you call endTransaction().

answered Apr 7, 2011 at 2:27

Joseph Earl

23.4k11 gold badges78 silver badges90 bronze badges

Comments

kharles · Accepted Answer · 2011-04-07 02:32:52Z

1

there's no explicit boolean type in sqlite tables? what data type is the COL_SYNED column you are trying to update?

and you will need to call db.setTransactionSuccussful()

edited Apr 7, 2011 at 2:32

answered Apr 7, 2011 at 2:25

kharles

3265 silver badges14 bronze badges

Comments

Crimsonland · Accepted Answer · 2011-04-07 02:39:12Z

0

I think there is a problem on your update..

You need to loop your array and update each one by one..

    private int _rowsAffected;

    foreach (var a in inArray)
    {

    _rowsAffected= db.update(TABLE, contentValues, COL_ID + " = (" + a +")", null);

    }

    db.Commit();
    db.setTransactionSuccussful(); 


if(_rowsAffected > 0)
//Success

Regards

answered Apr 7, 2011 at 2:39

Crimsonland

2,1943 gold badges25 silver badges43 bronze badges

Collectives™ on Stack Overflow

Android SQLite Update not working

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related