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