I noticed when getting values from a cursor there is a difference with GetString and GetDouble.

I used GetString even for REAL numbers.

But when the numbers are bigger than 1000000 GetString returns the numbers in scientific notation with only 6 digits truncating the rest.

Example:

GetDouble > 1497823.0

GetString > 1.49782e+06

It seems that GetString returns a Float number and not a Double.

123.45678 returns 123.4568.

Is this conversion done in B4A or in Android ?

If it's B4A it should be modified.

If it's Android could it be modified in the SQLite library or do we need to live with it and check the data type to get the precise value ?

The problem comes from this thread.

I used GetString even for REAL numbers.

But when the numbers are bigger than 1000000 GetString returns the numbers in scientific notation with only 6 digits truncating the rest.

Example:

GetDouble > 1497823.0

GetString > 1.49782e+06

It seems that GetString returns a Float number and not a Double.

123.45678 returns 123.4568.

Is this conversion done in B4A or in Android ?

If it's B4A it should be modified.

If it's Android could it be modified in the SQLite library or do we need to live with it and check the data type to get the precise value ?

The problem comes from this thread.

Last edited: