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!

APEX 5.1.4 Interactive Grid ISSUE with format mask

alby_bAug 3 2018 — edited Aug 3 2018

Hi all,

I've an interactive grid with number fields, with format mask FM999G999G990D00; the business request is to see only 2 decimal digits, even if on database column there are more than 2 decimal numbers

I notice a strange behaviour: my database table has columns A and B with these values:

AB
1008,3333333

On interactive grid I correctly see only 2 decimal on col. B

AB
1008,33

If I modify column A with 101 A and save, the result on database is:

AB
1018,33

but this is wrong because I have not modified column B; It seems like IG sends to database all the values that are on grid even if not changed.

For example, if I do the same thing with Oracle Forms this error doesn't happen.

Maybe there is something wrong  on my IG  or other?

Thanks a lot

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2018
Added on Aug 3 2018
0 comments
556 views