I think we can do more with recursive query like:
with recursive CTE (nKey,caption ,nkeyp) AS (
select id,name,pid FROM persons WHERE pid=:n
union all
select id,name,pid from persons
join CTE t
on t.nKey= persons.pid)
select * from cte ;
this sql statement is inserted to tsqlresult.sql .
I think that the procedure addchildren in mseuniverse example is no longer
valid?
We have not access to primary key (id) to perform a find ().
Regards.
Med
Nb: Id is primary key . pid is parent key .
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
mseide-msegui-talk mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
