Simon Slavin wrote: > On 30 Jun 2016, at 8:24am, Olivier Mascia <o...@integral.be> wrote: >> Of course writing straight code in C/C++ it's rather simple to emulate >> situations where you want to update some values in an existing row, >> creating the row if needed. > > The standard way of doing this is to do two commands: > > 1) INSERT without the REPLACE > 2) UPDATE > > When step 1 fails because the key values already exist you trap this > and explicitly ignore it in your code (commented, because you're being > nice to other programmers).
Trapping only the conflict violation while properly handling any other errors makes this even more complex. A better way is to try the UPDATE first, and if the data was not found (number of affected rows is zero), do the INSERT. Doesn't even need a comment. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
