brilliant! - it works - thanks On 14 December 2017 at 19:07, Clemens Ladisch <clem...@ladisch.de> wrote:
> Shane Dev wrote: > > On 14 December 2017 at 12:59, Clemens Ladisch <clem...@ladisch.de> > wrote: > >> Shane Dev wrote: > >>> Can we conclude there is no single CTE or other SQL statement which can > >>> update a branch of the tree starting with a flexibly specified node? > >> > >> That should be possible when you enable recursive triggers: > >> > >> begin > >> update hierarchy set status = null where id = old.id; > >> delete from vhierarchy where parent = old.id; > >> end; > > > > With your solution, how would you define the DELETE ON VHIERARCHY > trigger? > > That is the trigger. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
