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

Reply via email to