Does progress 4GL language support hierarchical queries?

[user3434918]

The simple question subscribed on progress site: Does progress 4GL language support hierarchical queries like Oracle (Connect by clause) or Sql Server(CTE)?

I have the following table:


Name parent
-----------------------
Elizabeth II null
Charles Elizabeth II
Andrew Elizabeth II
Edward Elizabeth II
Harry Charles
William Chales
James Edward
George William


Is there a script in progress that will generate the following output?


Elizabeth II
|_Charles
|_William
|_George
|_Harry
|_Andrew
|_Edward
|_James

Continue reading...