Adry wrote:


> Infact, sending a recordset with real values, rebuilding the recordset in 
> the server receiver these values lose the decimal separator (point).
> 
> The very problem is that this occours only on a specific server (Win 2K 
> Server - SP4 - XML 3.0 SP5 - SQL 2K Standard).
> Using other servers, infact, this problem doesn't occour.

> <xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
>  xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
>  xmlns:rs='urn:schemas-microsoft-com:rowset'
>  xmlns:z='#RowsetSchema'>
> <s:Schema id='RowsetSchema'>
>  <s:ElementType name='row' content='eltOnly' rs:updatable='true'>
>   <s:AttributeType name='QuantitaOreScaricata' rs:number='6' 
> rs:nullable='true' rs:writeunknown='true' rs:basecatalog='PortaleSapes'
>     rs:basetable='OrdiniAssistenzaCodComm' 
> rs:basecolumn='QuantitaOreScaricata'>
>    <s:datatype dt:type='r4' dt:maxLength='4' rs:precision='7' 
> rs:fixedlength='true'/>
>   </s:AttributeType>
>  </s:ElementType>
> </s:Schema>
> <rs:data>
>  <z:row QuantitaOreScaricata='12.75'/>

>  <z:row QuantitaOreScaricata='1275'/>

Is that processed on some system with locale settings where the decimal 
separator is not '.' but ',' or something else and where '.' might do 
something else (e.g. separate groups). That could explain that parsing 
12.75 throws out the '.' as it seems misplaced.
I don't know how you process the data but you might want to check what 
regional settings respectively locale is used to parse and format numbers.

-- 

	Martin Honnen --- MVP XML
	http://JavaScript.FAQTs.com/