I can create an xml doc. with a schema using VFP CURSORTOXML().

Mark

>Could anybody provide an example how to create a XML document from a cursor/table using existing xml Schema XSD file?
>
>For examle, there is a table:
>testtable (author c(25), subject c(25), content M, dt_created T, cost n(10,3), currency c(20))
>
>And the schema is:
>*-------------------------------------------
>(?xml version="1.0"?>
>
>(Schema name="XMLTEST" xmlns="urn:schemas-microsoft-com:xml-data" (xmlns:dt="urn:schemas-microsoft-com:datatypes">
>(description>
> Describes the schema for direct data update .
>(/description>
>(ElementType name="author" content="textOnly" dt:type="string"/>
>(ElementType name="subject" content="textOnly" dt:type="string"/>
>(ElementType name="content" content="textOnly" dt:type="string"/>
>(ElementType name="timeStamp" content="textOnly" dt:type="dateTime"/>
>(ElementType name="currencyUnit" content="textOnly" dt:type="string"/>
>(ElementType name="costValue" content="textOnly" dt:type="number"/>
>(ElementType name="note" content="eltOnly">
>(element type="author" minOccurs="1" maxOccurs="1"/>
>(element type="subject" minOccurs="1" maxOccurs="1"/>
>(element type="content" minOccurs="1" maxOccurs="1"/>
>(element type="timeStamp" minOccurs="1" maxOccurs="1"/>
>(/ElementType>
>(ElementType name="Cost" content="eltOnly">
>(element type="currencyUnit" minOccurs="1" maxOccurs="1"/>
>(element type="costValue" minOccurs="1" maxOccurs="1"/>
>(/ElementType>
>(/Schema>
>*----Please replace starting "(" with "<" above.
>*Sorry, entire message is not displayed otherwise.--------------------
>
>I will appreciate any input or advice