On Fri, 25 Apr 2014 09:22:20 +0100 (BST), olivier Ménard <men37...@yahoo.fr> wrote:
> Hello > > I tried, (with sqlite3 command line) : > > create table T(a primary key not null); > create table U(a references T not null); Shouldn't that be: create table U(a not null references T(a)); ? > insert into U values(4) > > and it works but i don't want to, because the value 4 is not in T. > I've tried PRAGMA foreign_keys first, but it's the same. Old version perhaps? -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users