On Jan 31, 2009, at 12:25 AM, Adam DeVita wrote: > Good day, > > If I write into the sqlite3 using the analyzer: > > create table mysns (SN int primary key, desc text); > insert into mysns (SN, desc) values (1,2); > create table t2 (mynum int, desc2 text, SN references mysns(SN) ); > > insert into t2 (mynum, desc2, SN) values (1,"two", 3); > > This insert didn't produce an error, despite the fact 3 isn't in table > mysns. Why?
Foreign keys are not supported. See the first entry in this list: http://www.sqlite.org/omitted.html > > > regards, > Adam > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
