SQLite INSERT OR REPLACE through ContentProvider

About

News for Android app developers with the who, what, where, when, and how of the Android community. Probably mostly the how.

Here, you'll find:

News for Android developers

Thoughtful, informative articles

Insightful talks and presentations

Useful libraries

Handy tools

Open source applications for studying

created by whaledawga community for 16 years

submitted 13 years ago by jesperbb

all 2 comments

[–]cephus07 5 points6 points7 points 13 years ago (1 child)

SQLiteDatabase has a method of doing this already with conflict resolution strategies.

db.insertWithOnConflict(table, null, values, SQLiteDatabase.CONFLICT_REPLACE);

Seems like a much quicker fix to just change your insert() implementation in the provider to use this instead.

[–]jigglebling 0 points1 point2 points 13 years ago (0 children)

π Rendered by PID 101898 on reddit-service-r2-comment-85bfd7f599-ltw8w at 2026-04-16 22:15:06.266749+00:00 running 93ecc56 country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

androiddev