My understanding is that it is still required even when SQLite is
compiled to support FK constraints.
From the SQLite.org docs
"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."
BTW, there is a newer version (1.0.72.0) at
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
-----Original Message-----
From: Greg Keogh
Sent: 5/28/2011 12:06 AM
>Are you sending the pragma to enable FK constraints?
>PRAGMA foreign_keys = ON;
That's only if you're compiling SQLite from the source code. I'm just
using the ADO provider. I've been looking for some configuration
setting somewhere that might alter what seems to be the default
behaviour of no FK constraints, but nothing so far.
Cheers,
Greg
