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!

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2013

Added on Jan 31 2013

#apex-discussions, #data, #database, #date, #region, #report, #validation

11 comments

21,576 views