Re: Hierarchical trees in Forms 6.0

Damian,

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

Initial state
Node tree depth
Label for the node
Icon for the node
Data

Here is the sql I used.

SELECT -1, level, name, null, name

   FROM reports
   CONNECT BY PRIOR ID = parent
   START WITH parent IS NULL

This is the table stucture for the reports table:

CREATE TABLE REPORTS

(ID   	NUMBER(3),
RPTNUM	NUMBER(3),
NAME   	varCHAR(40),
PARENT	NUMBER(3),
DES	varCHAR(255));

James Rowland (jrowland_at_chis.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 18:43:03 CET