Re: No tree structure in navigator style form generated from designer 6i

From: Rado <rkobularcik_at_atlas.sk>
Date: 17 Sep 2002 01:12:03 -0700
Message-ID: <4df8528a.0209170012.5d3f0089_at_posting.google.com>

Hi,

it is better to use this in some trigger (when-new-block-instance, when-button-pressed, ...):

---

ftree.delete_tree_node('tree_block.tree_item',Ftree.ROOT_NODE); ftree.add_tree_data('tree_block.tree_item',

  ftree.ROOT_NODE,
  ftree.PARENT_OFFSET,
  ftree.LAST_CHILD,
  ftree.QUERY_TEXT,
  'select -1 , level, name, '''',gliederung ' ||
  'from orgaeinheiten ' ||

  'start with orge_gliederung IS NULL ' ||   'connect by orge_gliederung = prior gliederung');

---

In my opinion the designer just copying the block hierarchy in the tree item, not data hierarchy.

Rado,
Slovakia.

Frank Heuer <fheuer_at_oekodata.de> wrote in message news:<Xns928B6A0ECD743fheueroekodatade_at_130.133.1.4>...
> Hallo!
>
> I'm working with Oracle DB 8.1.7, Designer 6i and Developer 6i on a WinNT
> SP6 machine.
>
> I've a table like this, similar to table emp with Kings, Managers and so
> on:
>
>
> CREATE TABLE ORGAEINHEITEN (
> GLIEDERUNG VARCHAR2 (15) NOT NULL,
> ORGE_GLIEDERUNG VARCHAR2 (15),
> NAME VARCHAR2 (15) NOT NULL,
> GUELTIG_J_N VARCHAR2 (1) NOT NULL,
> CONSTRAINT PK_ORGE
> PRIMARY KEY ( GLIEDERUNG );
>
> ALTER TABLE ORGAEINHEITEN ADD CONSTRAINT FK_ORGE_ORGE
> FOREIGN KEY (ORGE_GLIEDERUNG)
> REFERENCES ORGAEINHEITEN (GLIEDERUNG);
>
> I defined a Module as described in Online-Help "Generating navigator style
> item". The Module contains the Table usage of ORGAEINHEITEN whith following
> Bound Items:
>
> Item / Usage Sequence
> -----------------------------------------
> ORGE_GLIEDERUNG / 1
> NAME / 5
> GLIEDERUNG / 10
>
> and one unbound Item with "unbound type" = Custom and "display type" =
> Navigator Style Item. I use the template ofgpc1t.fmb and the Library
> ofgstnd1.olb for generation.
>
> The generated and compiled form then shows the Tree control and a MAIN-
> Node. But when I expand the Mainnode, the data is just displayed in one
> level. The data is not displayed in a tree structure. So I executede the
> following SQL-Statement in SQL Plus:
>
> "select -1 , level, name, '',gliederung
> from orgaeinheiten
> start with orge_gliederung IS NULL
> connect by orge_gliederung = prior gliederung;"
>
> and the resultset show level up to 5 in my data.
>
> Can someone please give me some help and a more detailed explanation how to
> build a Forms Module with a hierarchical tree item.
>
> Frank
> Germany
Received on Tue Sep 17 2002 - 10:12:03 CEST