To make clearer my former post, (not arguing against the current
bahaviour of "INSERT OR REPLACE"), the usage (and misunderstanding) I
had with INSERT OR REPLACE was a simple shortcut of 2 statements :
- DELETE : erasing completely old values, with a constraint that no
deletion should occur if not replaced by new values,
and then INSERT : filling complete rows with new values, some of them
replacing the deleted ones, and with no alteration of constraint rules
enforced on the table.
Regards.
Jean-Marie Cuaz
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
