Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XmlToCursor()
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Title:
XmlToCursor()
Miscellaneous
Thread ID:
00737045
Message ID:
00737045
Views:
49
I get this XML from a function created with ADO.NET:
<NewDataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true">
      <xs:complexType>
        <xs:choice maxOccurs="unbounded">
          <xs:element name="Table">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="code" type="xs:string" minOccurs="0" />
                <xs:element name="descr" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <Table>
    <code>S1</code>
    <descr>TEST        </descr>
    <descrf>TEST DESCR        </descrf>
  </Table>
</NewDataSet>
If i use XmlToCursor( xml, "testTable", 4), it create the cursor but the colums are created as char(1), and the data is truncated.

What's up doc ?
Next
Reply
Map
View

Click here to load this message in the networking platform