|
|
Posted by ven on 11/06/05 15:01
sorrry i forgot one think the select should return somethin like :
root 1 name1
root 2 name2
root 3 name3
4 1 name4
5 1 name5
6 1 name6
7 4 name7
Uytkownik "ven" <venome_@poczta.onet.pl> napisa w wiadomoci
news:dkkuca$grf$1@news.onet.pl...
> hello i have a table with four fields : name_id, name, tree_id, level with
> these data:
>
> 1 name1 001 1
> 2 name2 002 1
> 3 name3 003 1
> 4 name4 001001 2
> 5 name5 001002 2
> 6 name6 001003 2
> 7 name7 001001001 3
>
> tree:
>
> 1-
> - 4
> -7
> -5
> -6
> 2-
> 3-
>
> and procedure which add nodes to tree looks
> tree.add(idparent,idchild,name)
>
> how to write select which returns idparent,idchild and name then i can add
> nodes in loop reading datareader ?
>
[Back to original message]
|