From textfield to currency

Alexis_Colon_Lugo · December 28, 2013, 10:25pm

Dim dd As Currency

WebTextField.Text=“1,456.98”

dd=val(WebTextField.Text)

dd it return 1.0 and no 1456.98

way

Marc_Zeedar · December 28, 2013, 10:38pm

Probably the comma in the text confused the val() function.

Tim_Hare · December 29, 2013, 12:08am

Use CDbl instead of Val.

Alexis_Colon_Lugo · December 29, 2013, 2:40am

thanks tim

Alexis_Colon_Lugo · December 29, 2013, 3:50am

Tim no Works
Dim vTiendaRep as Currency
vTiendaRep=CDbl(TxtTiendaRep.Text)

Alexis_Colon_Lugo · December 29, 2013, 3:55am

Thanks
i found the Problem

is Working now

Alexis_Colon_Lugo · December 29, 2013, 10:48pm

Hi
What is the best practice use Currency or Double and on the data base use the same if i use double on Xojo use Double on the DB ?