I found out recently that sometimes on a per-session basis, you have to turn the foreign key check on. So even though one provider has it on by default, another may not.
http://www.sqlite.org/pragma.html#pragma_foreign_keys I had a SQLite3 Database manager running, and the SQL to delete a row from the table worked, however, the exact same line (Copied from code to the S3DM) didn't. Found this link on the interwebz, and it worked. On Mon, Oct 1, 2012 at 8:10 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > David Richardson wrote: > > I’m having some sort of bug with system.data.sqlite. > > when I try to delete it should cascade , but 'on cascade delete’ does > NOT work. > > In SQLite, it's called "on delete cascade": > > sqlite> pragma foreign_keys=on; > sqlite> create table parent(id integer primary key); > sqlite> create table child(id integer references parent(id) on delete > cascade); > sqlite> insert into parent values(1); > sqlite> insert into child values(1); > sqlite> select * from child; > 1 > sqlite> delete from parent where id = 1; > sqlite> select * from child; > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
