Tree View list box

[kmswetha]

Hi,

Am using tree view by using hierarchy function.Everything is coming up well.

But when I want to put it in list box everything turns out to be gray.Is there any specific reason for this?

[MarcoWedel]

Hi,

this script generates a list of all parent nodes paths:

i.e. each subpath of path 'A/A0/A00/A00001' is calculated and stored in a new field 'Path_Select' associated to the given field 'Path'.

Left(PATH,Index(PATH&'/','/',IterNo())-1)

extracts those subpaths beginning from the first character to the IterNo-th occurence of the delimiter '/'.

While IterNo()<=SubStringCount(PATH,'/')+1

iterates over each input row as often as the delimiter '/' is included in the path (+1).

hope this helps

regards

Marco