<?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