Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xmltocursor
Message
From
06/08/2008 05:56:24
Thomas Borgmann
Koblenz, Germany
 
 
To
06/08/2008 05:34:38
Kurt Vanhauwaert
Kv-Computing
Belgium
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Re: Xmltocursor
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01335748
Message ID:
01336795
Views:
17
Hi Kurt,

this XML-Schema won't do with XMLTOCURSOR, which can only iterate those XML-files, that contain just one cursor. Your schema includes 2 (or 3?). So you might have a look at XMLAdapter or MSXML itself.

>hi Cetin,
>
>i'm getting confused here :)
>
>i try with xmltocursor but i get the know error.
>
>the xml and the xsd are both in the same directory.
>
>
> <?xml version="1.0" ?>
>- <AnimalExport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://Sanitrace.EAI/SanitraceRepository/SanitraceServices/AnimalExportSchema">
>- <Animal>
>  <ANTP_CDE>BOV</ANTP_CDE>
>  <CDE>BE33272414</CDE>
>  <MACT_CDE>BE</MACT_CDE>
>  <MRK_CDG>0</MRK_CDG>
>  <MRK_NBR>33272414</MRK_NBR>
>  <FCLT_CDE>BE30980067</FCLT_CDE>
>  <SNUN_CDE>BE30980067-0101</SNUN_CDE>
>  <CDE_MHR>BE 9 32759759</CDE_MHR>
>  <BLST_CDE>N</BLST_CDE>
>  <ANSB_CDE>BOV</ANSB_CDE>
>  <ANRT_CDE>MEAT</ANRT_CDE>
>  <GNDR_CDE>FEM</GNDR_CDE>
>  <HRTP_CDE>W</HRTP_CDE>
>  <BTH_DTE>2003-08-27T00:00:00</BTH_DTE>
>  <PRUN_REF_NBR>3303604071</PRUN_REF_NBR>
>  <FCLT_CDE_BTH>BE30980067</FCLT_CDE_BTH>
>  <VGN_FLG>true</VGN_FLG>
>  <VRV_IDN_CRD_FLG>false</VRV_IDN_CRD_FLG>
>- <History>
>  <PPR_CDE>BTH</PPR_CDE>
>  <TUST_CDE>INV</TUST_CDE>
>  <DTE_FRM>2003-08-28T00:00:00</DTE_FRM>
>  </History>
>- <Risk>
>  <DES>Brucellosis</DES>
>  <RSST_CDE>4</RSST_CDE>
>  <RIST_CDE>1</RIST_CDE>
>  </Risk>
>- <Risk>
>  <DES>Tuberculosis</DES>
>  <RSST_CDE>3</RSST_CDE>
>  <RIST_CDE>1</RIST_CDE>
>  </Risk>
>- <Risk>
>  <DES>Leucosis</DES>
>  <RSST_CDE>3</RSST_CDE>
>  <RIST_CDE>1</RIST_CDE>
>  </Risk>
>- <Risk>
>  <DES>Foot-and-mouth disease</DES>
>  <RSST_CDE>2</RSST_CDE>
>  <RIST_CDE>1</RIST_CDE>
>  </Risk>
>  </Animal>
>  </AnimalExport>
>
>
>the xsd is
>
><?xml version="1.0" encoding="utf-8"?>
><xs:schema xmlns:tns="http://Sanitrace.EAI/SanitraceRepository/SanitraceServices/AnimalExportSchema" elementFormDefault="qualified" targetNamespace="http://Sanitrace.EAI/SanitraceRepository/SanitraceServices/AnimalExportSchema" id="AnimalExportSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema">
>	<xs:element name="AnimalExport">
>		<xs:complexType>
>			<xs:sequence>
>				<xs:element minOccurs="0" maxOccurs="unbounded" name="Animal">
>					<xs:complexType>
>						<xs:sequence>
>							<xs:element minOccurs="0" maxOccurs="1" name="ANTP_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="MACT_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="MRK_CDG" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="MRK_NBR" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="FCLT_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="SNUN_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="CDE_MHR" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="CDE_MHR_GTC" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="BLST_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="TUBR_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="BLO_STA_CMN" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ANSB_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ANRC_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ANRT_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ASRV_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="GNDR_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="HRTP_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="BTH_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="IMO_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="EPO_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="PUR_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="DTH_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="PRUN_REF_NBR" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="EXT_GRP_NBR" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="EXT_SGP_NBR" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="FCLT_CDE_BTH" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="FCLT_CDE_END" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ORI_NBR" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="CRF_NBR" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="CTRY_CDE_IMO" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="CTRY_CDE_EPO" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="DNA_ANA_FLG" type="xs:boolean" />
>							<xs:element minOccurs="0" maxOccurs="1" name="DNA_ANA_REF_NBR" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="DNA_SMP_FLG" type="xs:boolean" />
>							<xs:element minOccurs="0" maxOccurs="1" name="DNAQ_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="VGN_FLG" type="xs:boolean" />
>							<xs:element minOccurs="0" maxOccurs="1" name="PPT_VRS_NBR" type="xs:int" />
>							<xs:element minOccurs="0" maxOccurs="1" name="PPPR_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ANPP_PNT_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="VRV_FLG" type="xs:boolean" />
>							<xs:element name="VRV_IND_CRD_FLG" type="xs:boolean" minOccurs="0" maxOccurs="1" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ABFY_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ABSP_CDE_BAG" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ADSP_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ANCP_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="NRS_MHR_FLG" type="xs:boolean" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ANPR_CDE_BAG" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="AMQL_CDE_BAG" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="VRV_IDN_CRD_FLG" type="xs:boolean" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ANVS_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="ANVN_CDE" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="VRV_NAM" type="xs:string" />
>							<xs:element minOccurs="0" maxOccurs="1" name="BTH_WGH" type="xs:decimal" />
>							<xs:element minOccurs="0" maxOccurs="1" name="FRT_DLV_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="LST_DLV_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="FRT_MLK_DTE" type="xs:dateTime" />
>							<xs:element minOccurs="0" maxOccurs="1" name="FRT_NUR_DTE" type="xs:dateTime" />
>							<xs:element name="LST_UPD_DTE" type="xs:dateTime" maxOccurs="1" minOccurs="0" />
>							<xs:element minOccurs="0" maxOccurs="unbounded" name="History">
>								<xs:complexType>
>									<xs:sequence>
>										<xs:element minOccurs="0" maxOccurs="1" name="VTY_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="VTY_NAM" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSP_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSP_NAM" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSP_STR" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSP_NBR" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSP_ZIP" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSP_CTY" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSP_MCP" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSP_CTRY_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="BLST_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="BLO_STA_CMN" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RIQU_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RIQR_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSK_QAL_CMN" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="PPT_VRS_NBR" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="PPR_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="PBST_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="PPT_BLO_STA_CMN" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="PBRS_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="TUST_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="TUBR_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="DTE_FRM" type="xs:dateTime" />
>									</xs:sequence>
>								</xs:complexType>
>							</xs:element>
>							<xs:element minOccurs="0" maxOccurs="unbounded" name="Risk">
>								<xs:complexType>
>									<xs:sequence>
>										<xs:element minOccurs="0" maxOccurs="1" name="DES" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RSST_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RIST_CDE" type="xs:string" />
>										<xs:element minOccurs="0" maxOccurs="1" name="DTE_FRM" type="xs:dateTime" />
>										<xs:element minOccurs="0" maxOccurs="1" name="DTE_TO" type="xs:dateTime" />
>										<xs:element minOccurs="0" maxOccurs="1" name="RIOG_CDE" type="xs:string" />
>									</xs:sequence>
>								</xs:complexType>
>							</xs:element>
>						</xs:sequence>
>					</xs:complexType>
>				</xs:element>
>			</xs:sequence>
>			<xs:attribute name="User" type="xs:string" />
>			<xs:attribute name="SecurityToken" type="xs:string" />
>			<xs:attribute name="ReturnCode" type="xs:string" />
>			<xs:attribute name="ReturnMessage" type="xs:string" />
>		</xs:complexType>
>	</xs:element>
></xs:schema>
>
Best Regards
-Tom

Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform