Oliver Peters <oliver....@web.de> wrote: > reproduction > ------------ > > CREATE TABLE staff_01( > id INTEGER PRIMARY KEY AUTOINCREMENT, > id_staff_editor INTEGER NOT NULL, > code CHAR(2) NOT NULL, > FOREIGN KEY(id_staff_editor) REFERENCES staff(id) > ); > > INSERT INTO staff_01(id_staff_editor,code) VALUES(1,'CB'); > > > PRAGMA foreign_keys = ON; > > CREATE TABLE staff_02( > id INTEGER PRIMARY KEY AUTOINCREMENT, > id_staff_editor INTEGER NOT NULL, > code CHAR(2) NOT NULL, > FOREIGN KEY(id_staff_editor) REFERENCES staff(id) > ); > > INSERT INTO staff_02(id_staff_editor,code) VALUES(1,'CB'); > > For the last insert I get: > > "Error: near line 20: no such table: main.staff"
And indeed, there is no such table. What is your question? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users