Hi Bonnie,

I didn't mention that but I'm using the Compact Framework, and yes there is an inline schema in the XML coming from VFP, this schema is totally valid and has the right precisions for all decimals fields.

As I'm starting vacation tomorrow I'll leave this like it is now, I have tons of other stuff to finish before today... of course :P

Thanks

>Sylvain,
>
>Well, I'm not sure exactly why the schema isn't getting properly read into the .NET dataset. You *do* have an inline schema in the XML coming from Fox, right?
>
>If this .NET DataSet is of a known format, maybe it would be better to create an .xsd for your DataSet in .NET and use a Typed DataSet. Then, when you read it, you would use the XmlReadMode.InferSchema.
>
>I haven't used anything other than just plain decimal in my .xsd schemas (even though they may be different on the database, I'm using SQL Server), so I'm not 100% sure if this would work correctly, but I don't see why not.
>
>Sorry I couldn't offer more suggestions. =(
>
>~~Bonnie
>
>
>>Hi,
>>
>>I use the VFP XmlAdapater to create an XML DataSet that is sent to a .NET application through a webservice, on the other site I use a DataSet.ReadXML call to load the data into my dataset. Later I use a DataSet.WriteXML call to send back the data to VFP. Everything works fine except the decimals, both VFP and .NET messes with them!
>>
>>I did this to check for the differences between the XML files generated by both, and below the code I pasted all numeric fields from both the Vfp.xml and Dotnet.xml files
>>
>>
>>'Writes to disk the XML received from VFP
>>Dim oStream As New StreamWriter("vfp.xml")
>>oStream.Write(cXML)
>>oStream.Close()
>>
>>

>>'Loads XML received from VFP in a new DataSet
>>Dim oDS As New DataSet("VFPDataSet")
>>Dim oXMLTR As New XmlTextReader(New StringReader(cXML))
>>'oDS.ReadXmlSchema(oXMLTR)
>>oDS.ReadXml(oXMLTR, XmlReadMode.ReadSchema)
>>oDS.AcceptChanges()
>>
>>'Writes to Disk XML of the DataSet
>>Dim oFileStream As New FileStream("dotnet.xml", _
>>    FileMode.Create, FileAccess.Write)
>>Dim oXMLTW As New XmlTextWriter _
>>    (oFileStream, System.Text.Encoding.UTF8)
>>oDS.WriteXml(oXMLTW, XmlWriteMode.WriteSchema)
>>oXMLTW.Close()
>>oFileStream.Close()

>>
>>In the Vfp.xml file, for all restriction base="sxd:decimal", both the Totaldigits and fractiondigits are present and corresponding to the backend databases, but in Dotnet.xml, for all decimal fields, the totalDigits and FractionDigits fields disappeared! So when I load back in VFP, all numeric fields ends up being N(20,19)...
>>
>>Can anybody help me ? Why is that and how can I fix that ?
>>
>>Thanks,
>>Sylvain Bujold