Oliver Peters <oliver....@web.de> wrote: > This sql code works in the two cases but AFAIK ;-) it shouldn't in the second > > PRAGMA foreign_keys = ON; > > CREATE TABLE staff_02( > id INTEGER PRIMARY KEY AUTOINCREMENT, > id_staff_editor INTEGER NOT NULL, > code CHAR(2) NOT NULL, > UNIQUE(code) > FOREIGN KEY(id_staff_editor) REFERENCES staff_02(id) > ); > > INSERT INTO staff_02(id_staff_editor,code) VALUES(1,'CB');
The first record gets inserted with an id of 1, which just happens to match the value of id_staff_editor. See what this would do: INSERT INTO staff_02(id_staff_editor,code) VALUES(1000,'CB'); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
