SqlDbx
You are not logged in.
Pages: 1
In version 4.2 we got back a bug which was already fixed before - Column Totals have too many decimal zeros even if data itself is integer.
Because of this the total line is not fully visible and you have to expand the with of each column to see totals.
And because of this a result no longer fits to the window
For example
18166
20875
21225
20545
19969
13734
19801
22808
24501
27653
2092.... -- total line is useless until you make a column wider
You have to drag the column boarder to see the full number 209277.00000000
It looks like the summed numbers are displayed according to the column declaration no matter what data looks like.
So if column is NUMBER(15,6) then it always be 6 decimals even if they all are zeros.
And if column is declared as NUMBER then it always be 8 decimal zeros
Please trim trailing zeros in the total line
Last edited by garbuya (2014-06-25 13:29:46)
Offline
Unable to reproduce this issue. What database you use?
Offline
Oracle 11g
Number of zeros depends on how you define column
If you define column as NUMBER you will get 8 zeros
Last edited by garbuya (2014-06-26 16:11:30)
Offline
Format of total row depends on settings in Tools->Options->Results.
In your case I suspect you do not have "Trim Trailing Zeroes" set.
Probably for totals some of the settings on this page should be ignored.
Offline
Pages: 1