Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Javascript not allowing precision greater than 0.000001 in an Interactive Grid

PaulPNov 5 2023 — edited Nov 5 2023

Oracle 19.2

APEX 23.1.4

I have an interesting precision issue. I cannot enter more than 5 zeros after the decimal point in an interactive grid. I have no validations or min/max attributes set on the column

0.000001 - no error

0.0000001 - ERROR raised ??

0.0000011111 - no error

I get the following error message in the browser console

The database on the other hand allows that precision. Is this a precision limit in IG? Why doesn't it match the database precision? How do other scientists using IG's get around this?

PaulP

Comments
Post Details
Added on Nov 5 2023
3 comments
294 views