Josef.Gschwendtner@Quattro-Soft.de [firebird-support]
2016-12-05 16:39:17 UTC
Hi,
I have a table with hierarchical data.
Fields:
PK
PK_Parent
Name
I would need a statement to fill a tree with the data of this table.
The sub nodes of each node should be sorted alphabetical.
I think one can define such a statement with windows functions (FB3).
Could anybody provide me with some example-code to do this.
Thank you very much,
Josef
I have a table with hierarchical data.
Fields:
PK
PK_Parent
Name
I would need a statement to fill a tree with the data of this table.
The sub nodes of each node should be sorted alphabetical.
I think one can define such a statement with windows functions (FB3).
Could anybody provide me with some example-code to do this.
Thank you very much,
Josef