I need a procedure written in vb 6 that will create a hierachical xml file from
an ado recordset.
In attached file I have included a xml file saved with the classic vb method
[login to view URL](Rst,adpersistxml).
You can open this as a recordset and see that this has
the following fields :
OrderID
CustomerID
EmployeeID
...
...
...
ShipCountry
ShipCity
I require to save this recordset to an xml file , but first the user will
supply the name of one or many fields in the recordset that will be used
by the procedure to create a hierarchy according to these field names.
Example 1
Lets say the user wants to group on the field name ''Ship Country''
The resulting xml file will create for each country an element
.Under each country element it will create as many elements as the rest of the field names in the recordset with their values.
You can see how the outputshould be in attached doc(ScreenShot 1)
Example 2
Lets say the user wants to group on the field name ''Ship Country'' and ''ShipCity''
The resulting xml file will create for each country an element and under each country element it will create one element
for each city it [login to view URL] each city it will create as many elements as the rest of the field names in the recordset with their values.
(See ScreenShot 2)
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
windows 98, 2000, millenium, xp