update sqlite db row when opened from listview in android

Question

I have created a listview from an sqlite db and when i click it, it opens up the corresponding text, I want to add it to a favourites folder by clicking a button which updates a column in the row to "y". Any help would be appreciated

nithin y.n.v · Accepted Answer · 2017-04-07 15:12:49Z

1

You can use the update query

pssQliteHelper = PSSQliteHelper.getInstance(context); 
SQLiteDatabase db = pssQliteHelper.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put("y", true);  
db.update(TABLE_NAME, contentValues,  " id = '" + dbInsertionId + "'",null); 
db.close();

edited Apr 7, 2017 at 15:12

nithin y.n.v

1662 silver badges14 bronze badges

answered Apr 7, 2017 at 11:49

fightingCoder

5943 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

update sqlite db row when opened from listview in android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related