Hello Folks,

I have a scenario where I have XML data in complex hierarchy. One of the biggest problem that I have is: how to create TEMP-TABLE structure for really complex XML hierarchies. For example my XML data is in this format:

SearchLIst

     Items

          SearchItem

               IndexItem

                    Name

                    Value

                    Size

                    ColumnIndexList

                              RecordId

                              DocId

                    MultiValueList

                              Data 1

                              Data 2

               CLOSEIndexItem

               Operator

               Displayed

          CLOSESearchItem

     CLOSEItems

CLOSESearchList

As you can see that the above (please see the attached document for exact XML) hierarchy is very complex. I am having a difficulty in creating a TEMP-TABLE for the mentioned XML. After reading through the tutorial Working with XML I learned about a Progress utility called bproxsdto4gl. I am waiting for my provider to send me this XSD file so that I could use this utility.

Another question I have is - What is the best way to create TEMP-TABLE definitions? Using bproxsdto4gl OR READ-XML which accepts schema definition as well.

Technologies I am using:

Progress: 10.2A

Presentation: WebSpeed, IIS

Tools: OpenEdge Architect

Thanks for your help!!