Press "Enter" to skip to content

Know How To Use Check Box Mapping Of Other Values Property In Oracle Forms

Check Box Mapping of Other Values in Oracle Forms specifies how any fetched or assigned value that is not one of the pre-defined “checked” or “unchecked” values should be interpreted. Means suppose you have specified Value When Checked property to ‘Y’ and Valued When Unchecked property to ‘N’ and the value is coming from database is ‘X’ then ‘Check Box Mapping of Other Values’ property handles to how the check box will behave in that condition, means it would be unchecked or checked or disabled.

Default value of this property is:

NOT ALLOWED

The following settings are valid for this property:

Not Allowed  

Any queried record that contains a value other than the user-defined checked and unchecked values is rejected and no error is raised. Any attempt to assign an other value is disallowed.

Checked  
Any value other than the user-defined unchecked value is interpreted as the checked state.

Unchecked
Any value other than the user-defined checked value is interpreted as the unchecked state.

See the examples of Check Box from the following links:

https://www.foxinfotech.in/2014/12/limiting-to-select-only-5-check-boxes.html
https://www.foxinfotech.in/2012/11/checkboxchecked-built-in-in-oracle-d2k.html

Check Box Mapping of Other Values Property Oracle Forms