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!

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.

Number field - Format mask and validation

partlycloudyJan 31 2013 — edited Feb 13 2013
APEX 4.2.1

When a page item with source=DB column uses a Number type and a currency format mask (FML999G etc), when the page is rendered, it properly formats the number.

The built-in Item is numeric validation appears to be handle this reasonably ok. i.e. both formatted values and only-digits both validate ok.

But any after-submit validations choke on the non-numeric characters in the field! Please don't tell me I have to a) create shadow items and/or b) replace() out the non-numeric characters in the validation.

After so many years and versions, why doesn't APEX have a simple, declarative, elegant solution to handle such a basic function?

Am I missing something?

Thanks

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 13 2013
Added on Jan 31 2013
11 comments
21,497 views