GMan Well-Known Member Licensed User Longtime User Jun 28, 2013 #1 Hoi, i am playing with Erels MySql-Sample and created and own databse with some testdatas. Its no problem to read out 2 datas, but when i try to read out a third one it causes an error. I placed that piece of cde drectly under the following line: Code: Copy lblPopulation.Text = NumberFormat2(m.Get("driver_kilometer"),0, 0, 0, True) & " (+)" Code: Copy (lightly modified) DriverMultiplikator = NumberFormat2(m.Get("driver_multiplikator"), 1, 0, 0, false) The dataset in the table contents only a one-digit integer (1-9) which i want to read out for calculating with other datas (already read out). The log shows me the correct datastring, read out correctly from the table. But why does the error appears ? The number is a simple INT (1 digit = 0-0) ?
Hoi, i am playing with Erels MySql-Sample and created and own databse with some testdatas. Its no problem to read out 2 datas, but when i try to read out a third one it causes an error. I placed that piece of cde drectly under the following line: Code: Copy lblPopulation.Text = NumberFormat2(m.Get("driver_kilometer"),0, 0, 0, True) & " (+)" Code: Copy (lightly modified) DriverMultiplikator = NumberFormat2(m.Get("driver_multiplikator"), 1, 0, 0, false) The dataset in the table contents only a one-digit integer (1-9) which i want to read out for calculating with other datas (already read out). The log shows me the correct datastring, read out correctly from the table. But why does the error appears ? The number is a simple INT (1 digit = 0-0) ?
GMan Well-Known Member Licensed User Longtime User Jun 28, 2013 #3 Erel said: Which error? Click to expand... Sorry, forgot it: NumberFormatException Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Jun 30, 2013 #4 There is probably an extra space in the string. Check: Code: Copy Dim s As String = m.Get("driver_multiplikator") Log(s & ", " & s.Length) Upvote 0
There is probably an extra space in the string. Check: Code: Copy Dim s As String = m.Get("driver_multiplikator") Log(s & ", " & s.Length)
