Main Region

Grid displays wrong data
1 answer | 337 views
CH
Christian86
Jan 28, 2015 10:20 +00:00

Hi

we display rows from an table with on column defined as NUMBER. (without precision and scale) When I select the Data in SQL Plus it shows the following number

alt text

in Foex it shows following number:

alt text

We can´t explan why.

Christian

3 comments
CH
Christian86 Jan 28, 2015 10:26 +00:00 

this is not the only number which is shown wrong... this is only an example

CH
Christian86 Jan 28, 2015 10:55 +00:00 

It seems to be a number problem. When I change the select statement in foex to an to_char, it shows the right value.

CH
Christian86 Jan 28, 2015 12:09 +00:00 

thank you!

MN
Matt Nolan
Jan 28, 2015 10:59 +00:00

Data for grids is stored in memory in an Ext JS data store and in the corresponding javascript data type that matches the grid query column data type e.g. VARCHAR2 -> string, Date -> Date, Number -> integer/float

The issue you describe is because of javascript and the fact that it only supports a maximum integer value of 9007199254740991 (53 bit integer). The effect on larger numbers is that they will lose their precision i.e. change, which is the behaviour you are experiencing.

Please make sure you issue a to_char on columns within your grid query for numbers larger than this maximum size.

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/MAX_SAFE_INTEGER

0 comments
You must log in or sign up to post questions and answers.