QV: Hierarchy

EMPLOYEE_MGR:
hierarchy (EMPLOYEE_KEY,MGR_ID,EMPL_NAME,,EMPL_NAME,EMPLOYEE_MGRPath,'|')
LOAD "EMPLOYEE_KEY",
    "EMPL_NAME",
    "POSTN_KEY",
    "HIRE_DT",
    "MGR_ID",
    EMPLOYEE_TYPE;
SQL SELECT
    "EMPLOYEE_KEY",
    "EMPL_NAME",
    "POSTN_KEY",
    "HIRE_DT",
    "MGR_ID",
    TYPE as EMPLOYEE_TYPE
FROM BISAMPLE."SAMP_EMPL_D_VH";

 

Listbox > show as treeview > set Separator