Android Question Select sum() and total() rounding

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 17, 2018

• #2

Please use [code]code here...[/code] tags when posting code.

Why aren't you using smart string for this?

What is the type of Valor column?

 

Upvote 0

rafaelcamara

Member

Licensed User

Longtime User

• Oct 17, 2018

• #3

Hi Erel,

The Value column is of type Double.

My intention is to bring the total direct through the sql, but I do not understand why it is returning like this. Does it have to do with the B4A version? I'm using version 8.3

 

Upvote 0

eps

Expert

Licensed User

Longtime User

• Oct 17, 2018

• #4

It's nothing to do with B4A. What variable types are you populating the amounts with in B4A? It looks like a type mismatch or it's converting/CASTing them to an INT/Whole Number.

 

Upvote 0

rafaelcamara

Member

Licensed User

Longtime User

• Oct 17, 2018

• #5

So this result is from the query itself without loading into a variable the field in the database is double

 

Upvote 0

OliverA

Expert

Licensed User

Longtime User

• Oct 17, 2018

• #6

What code do you use in B4A to display the output? What version of Android? On your PC, what version of SQLite? Are you 100% sure you are using the same datbase on both your PC and on your Android device?

 

Upvote 0

rafaelcamara

Member

Licensed User

Longtime User

• Oct 17, 2018

• #7

I find it strange why of rounding if the field in the database is DOUBLE, I noticed that it is only rounding when the decimal places is less than or equal (, 50), so much that the TotalAVencer field: 4849.67 returned correct. will be the B4A version?

 

Upvote 0

M

Mahares

Expert

Licensed User

Longtime User

• Oct 17, 2018

• #8

rafaelcamara said:

I find it strange why of rounding if the field in the database is DOUBLE

Click to expand...

1. Did you try using REAL for data type instead of double?
2. Did you try to use Round(total(Valor),2) or Total (Round(Valor,2)) to see what happens.
3. Did you try to extract the value as: rs.GetDouble(TotalTitulos)

 

Upvote 0

rafaelcamara

Member

Licensed User

Longtime User

• Oct 17, 2018

• #9

I extracted the value as: rs.GetDouble (TotalTitles) and it worked thanks for the help, but there was some change in B4A, because I have the application 4 years ago since version 2.7, and only now that it happened or did not realize it before?

 

Last edited: Oct 17, 2018

Upvote 0

OliverA

Expert

Licensed User

Longtime User

• Oct 17, 2018

• #10

rafaelcamara said:

only now that it happened or did not realize it before?

Click to expand...

Most likely this. Everything relating to SQLite in B4A (the methods that use SQLite) is dependent on the underlying Android implementation. So the only other explanation would be that something changed in Android's implementation of SQLite.

 

Upvote 0

eps

Expert

Licensed User

Longtime User

• Oct 17, 2018

• #11

Could it be something as simple as it only outputs 6 digits?

Can you make the data so that the following is true?

TotalVencidos: 3540.35
TotalAVencer: 4849.67
TotalTitulos : 8390.02

?

Something is substringing it or chopping it or CASTing it or ROUNDing it for some reason.. It might not be obvious what or why but it will be 'obvious' once it's worked out..

Without code of any sort it's almost impossible to help you.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 18, 2018

• #12

You should create a small project that reproduces the issue and upload it. As written above the B4A version is not relevant as B4A just passes the commands to the native SQL engine.

 

Upvote 0