APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn




Directly check the input

Written by Richard Weug. Posted in Plugins

With ApEx 4 we are able to shift a few kinds of validation directly to the items. Some of them are released with ApEx 4 like the “Number Textfield” or the “Value Required” selection box within the item configuration. But there are several other syntax related validations like telephone number, zip code or email addresses. Therefore I wrote a plug in, that validate the value against a Regular Expression and we can move most of the syntax validations to our items and making them responsible for that.

For a better usability, I build a AJAX process in which shows mismatches directly after the changes and not after submitting the page. Since Oracle and JavaScript use different flavors of Regular Expressions I need to implement an AJAX process, that validate against Oracle POSIX Expressions and not to the PERL Expressions, which is used by JavaScript.

Original article: http://www.dinh.de/wordpress/?p=216

download link: Download  |  http://apex.oracle.com/pls/apex/f?p=33751:8