Hi:
I've a database with a table- This table have 3 fields, two of them are TEXT, and the other one is REAL
I'm trying to display the REAL value, but can not get it
Sub CStr(val) As String
Return val
End Sub
Sub leer_registros
Dim rs As ResultSet
Dim where As String
where="%" & SpinnerMEs.SelectedItem & "%" & SpinnerAno.SelectedItem &"%"
'Lineas de Totales
rs=sql.ExecQuery2("select * from dias where dia like ? order by dia asc",Array As String(where))
Dim i As Int
Totales.Clear
For i=0 To rs.RowCount-1
Dim h As String
Log(rs.GetDouble("Horas"))
h=CStr(rs.GetDouble("Horas"))
rs.Position=i
Totales.Add(crea_row(rs.GetString("Dia"),h,rs.GetString("Tipo")),rs)
Next
end sub
I can not read REAL data form sqllite...I get this error
Everything works fine if i use a INTEGER instead of REAL and use rs.GetInt ...but the data must be REAL or FLOAT ( i need decimals )
Don't understand where the problem is with GetDouble function ... any help ?
Thank you very much in advance.