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!

Checkbox for Yes / No field?

724687Mar 12 2010 — edited Mar 15 2010
- I have a databasecolumn "needs_approval_YN" with a default value 'Y'
- I have in my Apex application a checkbox for this, that is only available for administrators (if user is no admin, the checkbox is read-only).
- I made a before update or inser trigger that replaces null values for this column in 'N'.

Problem now is that the (default) 'Y' value doesn't seem to be stored if the checkbox is read-only. So the checkbox displays 'Y', but once a non-admin user clicks save, the 'Y' value is ignored, and the trigger replaces the null with 'N'.

How can I solve this?
This post has been answered by Luis Cabral on Mar 15 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2010
Added on Mar 12 2010
8 comments
1,135 views