Hi Martin,
I Have a TMSESQLSCRIPT (DBTREE) and I want to generate a ttreeitemedit from the
result of the script.
How to navigate into the DBTREE?
Would you like to help?
Nb:
DBTREE.SQL is :
DELETE FROM TEMPINDEX;
INSERT INTO TEMPINDEX
with recursive dbtree (nKey,cKey ,lv) AS (
select cle,cast('.' as varchar(20))||cast(ndoc as varchar(5))||'.',0 FROM
DOCS WHERE ndocp=:n
union all
select cle,cKey||cast(ndoc as varchar(5))||'.',lv+1 from DOCS
join dbtree t
on t.nKey= DOCS.ndocp)
select * from dbtree;
Where nKey : Master Key
cKey : Caption
lv : Level of recursion
I tried many. I did not find a possible recursif procedure
are some fields are missing (nKey,cKey,lv) are enough?
------------------------------------------------------------------------------
_______________________________________________
mseide-msegui-talk mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
