Hi

Maybe this is something you can use:

http://www.winnetmag.com/SQLServer/Articles/ArticleID/8826/

regards
Jesper B. Kiær

Jezzper Consulting
Website : http://www.jezzper.com



-----"Sebastião Carlos Santos" <scarlosantos@...> wrote: -----


To: firebird-support@yahoogroups.com
From: "Sebastião Carlos Santos" <scarlosantos@...>
Date: 11/11/2004 7:59
Subject: [firebird-support] Hierarchical tree

I have the data in accordance with the structure listed below in a table

SQL> select
CON> id_sys_plataforma,
CON> id_sys_plataforma_pai,
CON> nome_plataforma
CON> from
CON> sys_plataforma
CON> order by
CON> id_sys_plataforma;

ID_SYS_PLATAFORMA ID_SYS_PLATAFORMA_PAI NOME_PLATAFORMA
================= ===================== ================================

1 1 Microsoft Windows
2 1 Microsoft Windows 9x
3 2 Microsoft Windows 95
4 2 Microsoft Windows 98
5 3 Microsoft Windows 95 SE
6 6 Linux

I need to mount the structure, in accordance with the example

- Microsoft Windows
----- Microsoft Windows 9x
--------- Microsoft Windows 95
------------- Microsoft Windows 95 SE
--------- Microsoft Windows 98
- Linux

I anticipate gratefulness for the aid



[Non-text portions of this message have been removed]





Yahoo! Groups Links