Hi Yuri,

The XSD Schema generated by the CURSORTOXML() function, although being compliant with the W3C recomendation, must follow some rigid rules. According to my tests, if this schema is modified in some of its aspects, these changes are not recognized by the XMLTOCURSOR() function. This means that there is not much flexibility in terms of the possible schemas structures. So, if you have a schema "strange" to the XMLTOCURSOR() function you are out of luck. This is understandable, since XMLTOCURSOR() uses MSXML 3.0 and this version of the Microsoft parser does not recognize XSD Schemas.

Your original question about generating XML documents from pre-defined XSD schemas might be solved by using a combination of SOM (Schema Object Model) and DOM (Document Object Model). I think you should use MSXML 4.0 to do that.