differentiate between update and inset in SQLite

Question

In SQlite how can I say if a row exists update it else createEntry? basically I want to have a table with single row and update it whenever single button pressed or so.

entry.open();
if(the row already exist)
entry.updateContact(1, Double.toString(db1), Double.toString(db2), Double.toString(db3));
else
entry.createEntry(Double.toString(db1), Double.toString(db2), Double.toString(db3));
entry.close();

You want to do an UpSert, check this out: http://stackoverflow.com/questions/418898/sqlite-upsert-not-insert-or-replace — Blundell, Apr 01 '13 at 10:44
the best and simple way is to create a single now when db is created first time and then update rest of time , this way your pre checking computation will lessen — Vipin Sahu, Apr 01 '13 at 10:54

score 0 · Answer 1 · answered Apr 01 '13 at 10:49

0

Sounds like you want to INSERT OR REPLACE. There's a blog post on this topic at http://www.buzzingandroid.com/2013/01/sqlite-insert-or-replace-through-contentprovider/

answered Apr 01 '13 at 10:49

miorel

1,863
2
14
18

differentiate between update and inset in SQLite

1 Answers1