On 2016/07/12 3:55 PM, R Smith wrote:
On 2016/07/12 2:12 PM, Dominique Devienne wrote:
In the session above, we can see that an insert or replace w/o an id
(the
PK) value,
results in the id changing in the table, which is not what we'd like.
etc.
By the way, another important problem with this is maintaining foreign
keys linked to ID fields. Best not to do it, or if you do, ALWAYS
specify the new ID yourself, never rely on the DB engine's feelings of
what the ID should be. (As I've mentioned many times before). :)
Cheers,
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
