* 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 foreign keys, is > > that correct?
> You may find Cody Pisto's utility useful. > http://www.sqlite.org/contrib > It creates sqlite triggers to enforce foreign keys. Ah, that's what I thought - my app can handle the constraints, it's really just the 'on cascade delete' feature I could do with the db handling. I found this earlier: http://www.justatheory.com/computers/databases/sqlite/ which seems to point out the voodoo needed. Thanks for the confirmation(s). -- 'Sweet Zombie Jesus!' -- Prof. Farnsworth Rasputin :: Jack of All Trades - Master of Nuns
