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) > > > >

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? > &g

RE: [sqlite] foreign keys? (sqlite3)

2005-02-01 Thread Cariotoglou Mike
that it actually DOES anything with this info, it is just there for you to act, not for the engine (yet) > -Original Message- > From: Dick Davies [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 01, 2005 3:52 PM > To: SQLite > Subject: [sqlite] foreign keys? (sqlite3) &

[sqlite] foreign keys? (sqlite3)

2005-02-01 Thread Dick Davies
The docs seem to say sqlite3 does'nt support foreign keys, is that correct? If so, I don't understand what ---8< # PRAGMA foreign_key_list(table-name); For each foreign key that references a column in the argument table,