Re: EAP Forms 6

From: news.burs.online.be <van_nieuwenhuyse_luytens_at_online.be>
Date: Mon, 1 Feb 1999 22:03:08 +0100
Message-ID: <7954pb$fn2$1_at_trex.antw.online.be>

[Quoted] Try this sql-statement in the DATA QUERY of your item:

        select  1,        level,
        emp.ename,        'C:\ORANT\FORMS45\DEMOS\ICONS\'||
         DECODE(level,1,'W_KING',
                                        2,'W_QUEEN',
                                        3,'W_KNIGHT',
                                            'W_PAWN')||
        '.ico',                    to_char(empno)from    emp
       connect by prior empno = mgr
       start   with JOB = 'PRESIDENT'

!!!(eventually replace the C:\ORANT by your oracle home or another path containing your icons or leave the column null). The meaning of the different Columns:
Column 1 = state number :1 = expanded node -1 = colapsed node 0 = leaf node

Column 2 = offset number (the level in the tree)
Column 3 = label varchar (the label of the treenode)
Column 4 = icon varchar2 (null allowed)
                         (the icon of the  treenode)

Column 5 = value varchar2 (the value bound to the label)

Good luck! Received on Mon Feb 01 1999 - 22:03:08 CET