>Hi there,
>
>i am trying to import XML data from two files.
>I Tried to use the XMLTOCURSOR function;
>
>XMLTOCURSOR(
, 'curResult', 512)
>
>This works fine, however the returned cursor
>only contains fields of the first XML tag,
>the rest of the data is placed in a MEMO field.
>
>Do i need a XSD? If yes, how do I create one?
>
>Hope somebody can help,
>
>Erwin
Erwin,
Probably your XML was an hierarchic one. In that case VFP XmlToCursor() simply concatanates inner tags to a single string and if length over char field lenght then creates a memo. ie:<root>
<level1>
<firstTag>MyValue</firstTag>
<level2>
<Tag2>Tag2</Tag2>
<Tag3>Tag3</Tag3>
<Tag4>Tag4</Tag4>
<Tag5>Tag5</Tag5>
<Tag6>Tag6</Tag6>
<Tag7>Tag7</Tag7>
</level2>
</level1>
</root>
Would create 2 fields, firstTag and Level2 and place all following tags into Level2 field.
Cetin