John Elrick wrote: > I'm a bit stumped and was curious if anyone had an elegant solution for > this problem. Assuming the following simplified example, my goal is to > cascade the deletes until all parent/child relations have been deleted. > The trigger removes the first level, but stops there (I believe this > behavior is documented). I can think of a delete query which would also > remove the first level, but am having a brain lock on any single query > which would walk a chain of arbitrary length. > > Am I missing something obvious?
No. > If not, does anyone have any brilliant ideas? > See http://article.gmane.org/gmane.comp.db.sqlite.general/17286/match=managing+trees+database for a method I use to manage trees in SQLite that works very well. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users