Combining multiple ADO recordsets into hierarchical XML

[wxdqz]

Greetings:I have from 1 to x ADO recordsets returned from calls to stored procedures.The recordsets are built in a totally data driven system and records fromeach recordset are related by keys in the data. The backend is Sybase 12.0so I can't use any Microsoft SQL Server syntax for retrieving a hierarchicalrecordset created in XML format. Sybase does not support the SHAPE & APPENDT-SQL statements. I can persist the individual recordsets to XML but notin a hierarchical format. I can build an XML file dynamically with code butI would prefer being able to users.save filename/datastream, adPersistXMLso the XML schema is automatically created and inserted into the XML document.Anyone have any ideas short of building an XML file dynamically and readingis back into a single ADO recordset control then save it again to get theschema?ThanksMark