Validation "Column Is NOT Zero" Honored When Entering Values of 00, 000, 0000 etc etc.
Last updated on OCTOBER 27, 2016
Applies to:Oracle Application Express (formerly HTML DB) - Version 5.0.2 and later
Information in this document applies to any platform.
An item has a validation of "Column Is NOT Zero" (or "Column Is NOT NULL or Zero). This works fine when entering a value of 0 in the filed and trying to apply the changes, the following error is shown to the end user
"<COL> Must Have A Value & Cannot Be ZERO"
However, if the end user enters values of 00, 000, 0000. That is a series of zeros, then on applying the changes the value is excepted and thus managing to enter erroneous values of zero. Do note, the series of zeros are shown as a single zero when the page is reloaded.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms