> 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 ?
>

> 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

"ven" <venome_@poczta.onet.pl> wrote in message
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 ?
>