On 9 Mar 2018, at 7:11pm, John Found <johnfo...@asm32.info> wrote: > "insert or replace" succeed without deleting the old rows from B.
"replace" means "delete the original row, then insert a new one". In your code, figure out whether you need INSERT or UPDATE, and do the appropriate one. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users