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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Added on Nov 5 2023

#ig

3 comments

186 views