On 7 September 2012 21:28, Dennis Klein <dennis.kl...@education-siemens.com> wrote: > Hallo, > > I am Using the latest Version of the precompiled shell Application from the > Download section, and the C/C++ Sources in Version 3.7.11 > > Now i created my tables, using Primary Key and Foreign Key Constraints. Then > I tested it, and inserted test data, with a foreign key which doesn't exist > as primary key in the referenced table. This worked. I also added valid data, > and tested the "ON UPDATE" and "ON DELETE" constraints. So if i delete a > entryset in the referenced table, the foreign key isn't set null. > > Is there a bug?
Did you do pragma foreign_keys=on; ? http://www.sqlite.org/foreignkeys.html#fk_enable They are off by default. > > Bye Dennis Klein Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users