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
