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+databasefor a method I use to manage trees in SQLite that works very well.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
