Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursortoxml fails
Message
From
08/03/2010 08:06:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Cursortoxml fails
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01453146
Message ID:
01453146
Views:
111
use code to create this xml file
<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<VFPData>
	<xsd:schema id="VFPData" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
		<xsd:element name="VFPData" msdata:IsDataSet="true">
			<xsd:complexType>
				<xsd:choice maxOccurs="unbounded">
					<xsd:element name="sync_profile" minOccurs="0" maxOccurs="unbounded">
						<xsd:complexType>
							<xsd:sequence>
								<xsd:element name="lastid" type="xsd:int"/>
								<xsd:element name="upddttm" type="xsd:dateTime"/>
							</xsd:sequence>
						</xsd:complexType>
					</xsd:element>
				</xsd:choice>
				<xsd:anyAttribute namespace="http://www.w3.org/XML/1998/namespace" processContents="lax"/>
			</xsd:complexType>
		</xsd:element>
	</xsd:schema>
	<sync_profile>
		<lastid>206443</lastid>
		<upddttm>2010-03-08T07:59:11</upddttm>
	</sync_profile>
</VFPData>
and this is the code:
CREATE CURSOR sync_profile (lastID i,upddttm t)
append blank
REPLACE lastid with 14438 , upddttm WITH DATETIME()
CURSORTOXML("sync_profile","sync_profile.xml",0,512,0,"1")
i get an error with this
XMLTOCURSOR("sync_profile.xml")


xml parser error; invalid at the top level of document


wha am I doing wrong here ????


Thnaks


Peter
Peter Cortiel
Next
Reply
Map
View

Click here to load this message in the networking platform