Just wondering when/if Richard
will make SQLite having referential Integrity a priority.
Is it on the TODO list? Is it #1 or #100 on this TODO list.
Because almost all other common databases have this.
Once it has this feature I think that it will become even more popular.
Signing off
Great Fan of SQLite
P.
> From: danielk1...@gmail.com> To: sqlite-users@sqlite.org> Date: Sat, 31 Jan
> 2009 00:28:05 +0700> Subject: Re: [sqlite] Foreign key support> > > 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
_________________________________________________________________
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_022009
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
