How to create trees with navigator

[blaghgi]

I have to make frame which represents hierarchy of products
Products are stored in table called Product(Product_id,Product name,...)
I like to have frame like this:
Computer
|Disk
|CPU
|Monitor
|...
...

 

[lewisp]

Step one is to create a record group that has 5 columns:

Column 1 is the state (NUMBER) -1 = collapsed, 1 = expanded
Column 2 is the level (NUMBER)
Column 3 is the node label (CHAR)
Column 4 is the name of an icon file (CHAR) can be null
Column 5 is the value of the node

The second step is to assign the record group to the tree after ensuring the tree is empty:

[tt]
IF FTREE.Get_Tree_Property('USER_TREE.TREE',FTREE.NODE_COUNT) != 0
THEN
FTREE.Delete_Tree_Node('USER_TREE.TREE',FTREE.ROOT_NODE);
END IF;

Ftree.Set_Tree_Property('USER_TREE.TREE',FTREE.RECORD_GROUP,<your record group>);

 

[blaghgi]

thanks