>"Assuming the library is compiled with foreign key constraints enabled, it must still be enabled by the application at runtime, using the PRAGMA foreign_keys <http://www.sqlite.org/pragma.html#pragma_foreign_keys> command."
Good grief! I didn't realise it was a SQL command. I put the statement before my INSERT statements and it does raise an error when I break the FK. This is a nuisance, as I'd have to enable it continuously in code. And since I'm planning to use the EF4 EDMX, lord knows I would get down to that level. >BTW, there is a newer version (1.0.72.0) at http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki Ooh, ta! Greg
