Thanks Benoît and Tobias!
Problem solved by changing the data-type of the fields in Sqlite from
INTEGER to BIGINT like so:
- select * from {table} into {temptable}
- create {newtable} (with BIGINT fields)
- insert into {newtable} select * from {temptable}
- drop {temptable}
Regards,
Herman
O
Le 17/06/2017 à 01:31, Tobias Boege a écrit :
On Sat, 17 Jun 2017, Herman Borsje wrote:
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
On Sat, 17 Jun 2017, Herman Borsje wrote:
> 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 Linu
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;
Da