Hi Gerald,

Are you sure that the latest .XSD file is used by XMLTOCURSOR()?

Can you come up with a repro code that creates a cursor, calls CURSORTOXML, calls XMLTOCURSOR() to create a new cursor and as a result some fields are missing from the new cursor?

Thanks,
Aleksey.


>We've got a problem. We are using VFP 7.0 and trying to use XML to transfer data across disparate networks, most likely via email. We are using CURSORTOXML make the transfer file and XMLTOCURSOR to retrieve it into the program.
>
>The problem is we've added some new fields to the cursor we're sending, and those fields are not showing up when we use XMLTOCURSOR.
>
>So, what gives? Are we doing something wrong in the code, or is there a bug?
>
>Thanks in advance...
>
>Here is the code we are using to test this.
>
>** Create the transfer file
>lcRemotepath = "C:\pwdata\somedata\REMOTE_TRANSFER\dept.xml"
>lnReturnResults = CURSORTOXML("department",lcremotepath,1,516,0,"dept")
>
>
>** Retrieve the data
>lcRemotepath = "C:\pwdata\somedata\REMOTE_TRANSFER\dept.xml"
>lnRecs = XMLTOCURSOR(lcRemotePath,"deptinfo",512)
>
>
>Data:
>
>

<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
><VFPData xml:space="preserve" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="dept.XSD">
>	<department>
>		<idepartmentid>          1</idepartmentid>
>		<cdepartmentname>Dept A                                  </cdepartmentname>
>		<lallowremote>false</lallowremote>
>		<cdeptpassword>               </cdeptpassword>
>		<dlastupdload>    -  -  T  :  :  </dlastupdload>
>		<dlastdownload>    -  -  T  :  :  </dlastdownload>
>		<dmodifiedon>2004-08-31T15:35:34</dmodifiedon>
>		<lremoteinsert>false</lremoteinsert>
>		<ldeptuploaded>false</ldeptuploaded>
>		<lempview>false</lempview>
>		<lempdel>false</lempdel>
>		<lempmod>false</lempmod>
>		<lpaydedview>false</lpaydedview>
>		<lpaydistmod>false</lpaydistmod>
>	</department>
>	<department>
>		<idepartmentid>          2</idepartmentid>
>		<cdepartmentname>Dept B                                  </cdepartmentname>
>		<lallowremote>true</lallowremote>
>		<cdeptpassword><Ý&            </cdeptpassword>
>		<dlastupdload>2004-08-30T08:45:24</dlastupdload>
>		<dlastdownload>2004-08-30T08:45:14</dlastdownload>
>		<dmodifiedon>2004-08-31T16:42:44</dmodifiedon>
>		<lremoteinsert>false</lremoteinsert>
>		<ldeptuploaded>true</ldeptuploaded>
>		<lempview>true</lempview>
>		<lempdel>true</lempdel>
>		<lempmod>true</lempmod>
>		<lpaydedview>true</lpaydedview>
>		<lpaydistmod>true</lpaydistmod>
>	</department>
>	<department>
>		<idepartmentid>          3</idepartmentid>
>		<cdepartmentname>Dept C                                  </cdepartmentname>
>		<lallowremote>false</lallowremote>
>		<cdeptpassword>               </cdeptpassword>
>		<dlastupdload>    -  -  T  :  :  </dlastupdload>
>		<dlastdownload>    -  -  T  :  :  </dlastdownload>
>		<dmodifiedon>    -  -  T  :  :  </dmodifiedon>
>		<lremoteinsert>false</lremoteinsert>
>		<ldeptuploaded>false</ldeptuploaded>
>		<lempview>false</lempview>
>		<lempdel>false</lempdel>
>		<lempmod>false</lempmod>
>		<lpaydedview>false</lpaydedview>
>		<lpaydistmod>false</lpaydistmod>
>	</department>
></VFPData>
>

>
>Schema:
>
>

<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
><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:lsDataSet="true">
>		<xsd:complexType>
>			<xsd:choice maxOccurs="unbounded">
>				<xsd:element name="department">
>					<xsd:complexType>
>						<xsd:sequence>
>							<xsd:element name="idepartmentid" type="xsd:int"/>
>							<xsd:element name="cdepartmentname">
>								<xsd:simpleType>
>									<xsd:restriction base="xsd:string">
>										<xsd:maxLength value="40"/>
>									</xsd:restriction>
>								</xsd:simpleType>
>							</xsd:element>
>							<xsd:element name="lallowremote" type="xsd:boolean"/>
>							<xsd:element name="cdeptpassword">
>								<xsd:simpleType>
>									<xsd:restriction base="xsd:string">
>										<xsd:maxLength value="15"/>
>									</xsd:restriction>
>								</xsd:simpleType>
>							</xsd:element>
>							<xsd:element name="dlastupdload" type="xsd:dateTime"/>
>							<xsd:element name="dlastdownload" type="xsd:dateTime"/>
>							<xsd:element name="dmodifiedon" type="xsd:dateTime"/>
>							<xsd:element name="lremoteinsert" type="xsd:boolean"/>
>							<xsd:element name="ldeptuploaded" type="xsd:boolean"/>
>							<xsd:element name="lempview" type="xsd:boolean"/>
>							<xsd:element name="lempdel" type="xsd:boolean"/>
>							<xsd:element name="lempmod" type="xsd:boolean"/>
>							<xsd:element name="lpaydedview" type="xsd:boolean"/>
>							<xsd:element name="lpaydistmod" type="xsd:boolean"/>
>						</xsd:sequence>
>					</xsd:complexType>
>				</xsd:element>
>			</xsd:choice>
>		</xsd:complexType>
>	</xsd:element>
></xsd:schema>