Re: Hierarchical Tree : Forms 6

From: may <mhlee_at_pagic.net>
Date: Mon, 27 Sep 1999 09:24:56 +0800
Message-ID: <938395950.827145_at_m5.pagic.net>

This works ,too.
1.create a table (Ex. test)
following is a copy from oracle form builder help

---

The columns in the record groups or queries used to populate a  hierarchical tree are:

initial state (number)
Node tree depth(number)
Label for the node(varchar2)
Icon for the node(varchar2)
Data(varchar2)
For example, the data in the table below would produce the following hierarchical tree:

  + - Car
  |

• - Airplane
  | - Boeing
  | - Boeing
  

Initial State Depth Label       Icon(NULL) Data
-1      1 Car                car
0        2 Honda                civic
1        1 Airplane         planet
0        2 Boeing                747
0        2 Boeing                 757
----------------------------------------------------------------------------

---

2.create a item in form
  change the property
  "type" : hierarchical tree
  "query_text" : select * from test

3.create a trigger on this item
  WHEN-NEW-ITEM-INSTANCE
  ftree.populate_tree('BLOCKNAME.ITEMNAME'); Received on Mon Sep 27 1999 - 03:24:56 CEST