When I retrieve a result from a sqlite3 database which holds very large
numbers in some fields, I get weird results. Up to 10 digits works okay,
but larger numbers are incorrect. Any ideas as to what's going wrong?
I am using Gambas 3.9.2 on Linux Mint 18.1
Tabledef: id INTEGER, name TEXT;
Database records:
id name
1234567890 test1
12345678901 test2
123456789010 test3
Public Sub Button1_Click()
Dim rs As Result
Dim con As New Connection
con.Name = "test.db"
con.Type = "sqlite3"
con.Open
rs = con.Exec("select * from test")
For Each rs
Debug Cstr(rs!id) & ": " & rs!name
Next
con.Close
End
Debug results:
FMain.Button1_Click.14: 1234567890: test1
FMain.Button1_Click.14: 0: test2
FMain.Button1_Click.14: 6714656: test3
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user