Hello everyone,
I am using Oracle APEX 24.2.8.
I have created a Switch page item. The defaults is ‘Y’ and ‘N’ for “On Value” and “Off Value” respectively.
I need the off value to be null.
I tried unchecking the “Use Defaults” switch, and left the “off Value” blank, but it still throws ‘N’ to the database.
I tried doing the same in the Component Settings page for the Switch item, but I found that the “Off Value” item is mandatory there however it's help text says the following:
Enter the value stored in the item if the user picks the Off option. This attribute can also be left blank if you want to store NULL when the Off option is selected. The value can be up to 255 characters long.
Note: This value is used if the item is populated with a value which does not match either the On Value or Off Value.
So, the help text says, it can be left blank. But the item itself is mandatory!
Any solution rather than handling it through a process to replace ‘N’ with null?