John Elrick <[EMAIL PROTECTED]> 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.
It's impossible in pure SQL, unless the DBMS supports special syntax for recursive queries, and/or recursive triggers. SQLite supports neither. You would have to code the recursion in your host application. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
