On Sun, Sep 18, 2016 at 4:19 PM, mikeegg1 <mikee...@mac.com> wrote:

> Thanks everyone. I was mis-equating REPLACE with UPDATE. I’ll change my
> code to “INSERT or IGNORE” and add an UPDATE.
>

For info, that's a common gotcha with SQLite. See [1] from 2-months ago,
but I'm sure the archives are littered with similar examples :). --DD

[1]
http://sqlite.1065341.n5.nabble.com/insert-or-replace-on-PK-and-UNIQUE-INDEX-td90407.html
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to