On 21 Jul 2017, at 10:50pm, Steven Friedman <sfried...@cryptonitenxt.com> wrote:
> sqlite> insert into t2 (c1) values (1); > Error: foreign key mismatch - "t2" referencing "t1" > sqlite> select changes(); "changes()" is returning the value of the last /successfull/ command which makes changes. Since the INSERT command changed, the value returned by "changes()" was not updated. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users