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