Text to Double problem from recordset

Var bValue as Text
Var MyBalance As double

bValue=Rs.Field(“DataBalance”).TextValue
i get this value in bValue 1,107.77

MyBalance=Double.FromText(bValue)
i get this value in MyBalence 1.

way any idea

thanks

You can try this:

MyBalance=ToDouble(bValue)

Because it takes localization in place.

Asamblea_Reg.BuscarSocio, line 85
This item does not exist
MyBalance=ToDouble(bValue)

Oh, yeah… sorry!

Try this:

[quote]Var n As Text = “1,000.23”
Var lc As New Xojo.Core.Locale(“EN”)
Var i As Double = Double.FromText( n, lc )

MessageBox( i.ToText )[/quote]

So, you need to give a Locale as parameter to do the conversion from text to double.

thanks
That works