Hi Henridk, I have the same issue and I think that can not be solved with insert facility which is only for basic usage. Instead we have to use query or rawquery in such way: http://stackoverflow.com/questions/531035/how-to-do-if-not-exists-in-sqliteI have not tried it yet, wut will soon do.
Hope this helps, Thierry. 2010/10/17 Hendrik Greving <fourhend...@gmail.com> > I'd like to have a sqlite table with rows of 4 entries: a row id, a > string and 2 integers and possibly more data later. I want the string to be > unique. What's the easiest way to write an adapter that insert new rows with > automatically replacing if the string already exists? Does > DatabaseUtils.InsertHelper > help? What is this for actually? How can I use CONFLICT_REPLACE? I could > probably get it working by making a query and then delete and inserting or > something like that, but I'm sure there is a better way. > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to android-developers@googlegroups.com > To unsubscribe from this group, send email to > android-developers+unsubscr...@googlegroups.com<android-developers%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en -- Thierry. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en