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