Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XMLToCursor Error Message
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
XMLToCursor Error Message
Divers
Thread ID:
00666633
Message ID:
00666633
Vues:
54
Hi

I used the following command to create an xml file:
CursorToXML("PMMaster","tmp\pmmaster.xml",1,512)

The output is:

<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<VFPData>
	<pmmaster>
		<acctno>DyeDsl</acctno>
		<allowpdisc>false</allowpdisc>
		<budprice>0.0000</budprice>
		<chargepst>false</chargepst>
		<cost>0.3510</cost>
		<desc>COLOURED DIESEL</desc>
		<glbpsale>!!!k)&gt;</glbpsale>
		<glclpurc>!!!zc?</glclpurc>
		<glclsale>!!!k)?</glclsale>
		<glppdisc/>
		<glpurc>!!!zc&gt;</glpurc>
		<glsale>!!!k)&lt;</glsale>
		<gstinprice>false</gstinprice>
		<gastax>0.0400</gastax>
		<group>FUELS</group>
		<heatingoil>false</heatingoil>
		<id>!!!#TC</id>
		<openstock>0</openstock>
		<ppdisc>false</ppdisc>
		<placard/>
		<price>0.4390</price>
		<reorders>0</reorders>
		<reorderw>0</reorderw>
		<roadtax>0.0000</roadtax>
		<size/>
		<stockadj>0</stockadj>
		<stockdate>2000-06-30</stockdate>
		<tconstant>1.0126000</tconstant>
		<tfactor>-0.0008421</tfactor>
		<trigger/>
		<type>L</type>
	</pmmaster>
</VFPData>
When I try to convert this data to a table using:

XMLToCursor("tmp\pmmaster.xml","tmp\pmmaster.dbf",512)

I get an error message which says:
XML parser error: Syntax error.node "VFPData" XML= 
<VFPData>
	<pmmaster>
		<acctno>DyeDsl</acctno>
		<allowpdisc>false</allowpdisc>
		<budprice>0.0
Does anyone know what the problem is? I get an error with or without a schema.

Thanks
Simon

Thanks Simon
Simon White
dCipher Computing
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform