Android Question EditBox decimal problem

E

elproing

Member
Hello,

I have another problem. When I insert number with decimal (3.5) in my EditBox and I insert this number in MySQL, I get 3.49990054798 in my table. Why is that?


This is my part of the code in B4A:

InsertPressureStartFRM1=FunctionBlocks.FloatWrite(EditPressureStartFRM1)

and my function wich I call


B4X: 
Public Sub FloatWrite (EditFloatData As EditText) As Float

Dim FloatData As Float

If    EditFloatData.Text <> "" Then

FloatData= Round2(EditFloatData.Text,1)

Else
If EditFloatData.Text = "" Then
FloatData=0.0
End If
End If

Return FloatData

End Sub
 
Sort by date Sort by votes

Erel

B4X founder
Staff member
Licensed User
Longtime User
Several mistakes in this code:
1. It is not needed.
2. Never ever use Round2.
3. Don't try to truncate the float number. Use NumberFormat or NumberFormat2 when you want to convert the number to string.

B4X: 
Public Sub FloatWrite (EditFloatData As EditText) As Float
 If IsNumber(EditFloatData.Text) Then Return EditFloatData.Text
 Return 0
End Sub
Later when you want to show the number to the user use NumberFormat.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question [Solved] Problem with float variable
Replies
3
Views
1K
Pflichtfeld
  • Question
Android Question [CLOSE]B4XTable ERROR when SetData
Replies
19
Views
3K
emexes
E
  • Question
Android Question B4XTable error adding line
Replies
1
Views
872
Erel
L
  • Question
Android Question FloatLabeledEditText inputtype
Replies
0
Views
1K
leitor79
L
M
  • Question
Android Question Mismatch in MD5 result when comparing with PHP
Replies
2
Views
3K
Meigionel TS
M
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…