RE: [sqlite] foreign keys? (sqlite3)

2005-12-08 Thread Griggs, Donald
Re: I've created a class that generates the necessary sql statements to describe the primary-foreign key relationship between two tables. Todd, I suspect there would be interest to some on the list. You may also want to review Cody Pisto's utility linked from page:

RE: [sqlite] foreign keys? (sqlite3)

2005-12-07 Thread tgreenwood
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've created a class that generates the necessary sql statements to describe the primary-foreign key relationship between two tables. This code is fairly rudimentary so far... Q: Is this interesting to anyone on this list? Q: If so, where should I

Re: [sqlite] foreign keys? (sqlite3)

2005-02-01 Thread Dick Davies
* Griggs, Donald <[EMAIL PROTECTED]> [0246 18:46]: > > > -Original Message- > > From: Dick Davies [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 01, 2005 3:52 PM > > To: SQLite > > Subject: [sqlite] foreign keys? (sqlite3) > > > > > > The docs seem to say sqlite3 does'nt support

RE: [sqlite] foreign keys? (sqlite3)

2005-02-01 Thread Griggs, Donald
> -Original Message- > From: Dick Davies [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 01, 2005 3:52 PM > To: SQLite > Subject: [sqlite] foreign keys? (sqlite3) > > > The docs seem to say sqlite3 does'nt support foreign keys, is > that correct? > > If so, I don't understand what

RE: [sqlite] foreign keys? (sqlite3)

2005-02-01 Thread Cariotoglou Mike
Sqlite parser DOES parse foreign key constraints. Try this: create table t1( id integer, id1 integer, id2 integer, id3 integer, foreign key (id1,id2) references anotherTable(id,id1), foreign key (id3) references somethingElse(id) ); pragma foreign_key_list(t1); However, this does not mean that