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

Reply via email to