I'm building an n-tier application for a client. They want the business layer of the application to be easily modified into a web-service in the future. Consequently, I'm using only XML to move data from the business layer DLL to the client. I've built a process where this DLL stores data from an OLEDB data source in the form of an ADO Recordset. It then stores the recordset, using the Save method of the recordset, as an XML file. The XML file is then read and stored as a string in a property on the DLL which the client reads. I then use XMLTOCURSOR to browse the data in the client executable. What I'm finding is that not all of the fields are being converted into the cursor because the schema that is saved with the recordset has data definition values like this:
1. dt:type='i2'
2. dt:type='ui1'
The XMLTOCURSOR code ignores the fields that have these datatypes. If I convert the values to dt:type='int', then they are converted. I could use STRTRAN to fix this, but that seems like a huge kluge. What am I missing? Is there a better way to do this?