SQLITE Database not updating the TABLE

Question

*TABLE NOT UPDATING*****HOW TO SOLVE THE PROBLEM

public String getElapsedTime(String session_id, String time) {
    db = this.getWritableDatabase();
    db.beginTransaction();
    db.setTransactionSuccessful();
    Log.d("CHINMAY", "Update in Sql get ElapsedTime " + session_id + "\n" + time);
    ContentValues cv = new ContentValues();
    cv.put(ELAPSED_TIME, time);
    db.update(TABLE_SESSION_TEST, cv, "session_id=?", new String[]{session_id});
    db.endTransaction();
    return "Checking Update";
}

Eric Bachhuber · Accepted Answer · 2020-02-26 11:30:24Z

2

You need to mark your transaction as "clean" by calling db.setTransactionSuccessful() before calling db.endTransaction(). If you do not set your transaction as successful, your changes are immediately rolled back as soon as the transaction is ended (as it assumes there was an error).

For more information, see the SQLiteDatabase documentation here

answered Feb 26, 2020 at 11:30

Eric Bachhuber

3,9722 gold badges22 silver badges26 bronze badges

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

6 Comments

Chinmay Moharana Over a year ago

I didn't understand how to clean.

Eric Bachhuber Over a year ago

db.update(TABLE_SESSION_TEST, cv, "session_id=?", new String[]{session_id}); db.setTransactionSuccessful(); db.endTransaction();

Eric Bachhuber Over a year ago

db.update() returns an integer of how many rows have been updated. When that code runs, does db.update() return a 0 or a 1? If it's a 0, check your data and query to make sure it's correct.

Chinmay Moharana Over a year ago

i changed the code and return boolean value output is coming toast.message as true.But database i checked is not displaying.

Chinmay Moharana Over a year ago

Actually i tried the code is updated after some time. But when i move to next activity the value is not coming immediately

|

Collectives™ on Stack Overflow

SQLITE Database not updating the TABLE

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related