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!

Disabling a Switch column in an Interactive Grid - Bug on Save?

Mark_BT52Mar 12 2020 — edited Mar 12 2020

Hi,

I have an IG with a M/F Gender column as a switch.

If another column is selected from an LOV then I populate (among other columns) the Gender.

This column is then set to disabled using a dynamic action on change of the LOV column,

However, even though the switch values are valid, the cells are errored with "Gender must match the values M and F"

Oddly, this works if it only one row being inserted or changed, but triggers the error if there are 2 or more.

If I change the switch to a radiogroup then everything works as expected. (But radio-groups in IGs look a bit messy at the moment I'm afraid)

I have put an example on apex.oracle.com by tweaking the Sample Interactive Grids page 36 to fire a DA to disable the On Leave Switch column.

(Note that changing the settings to be custom Y:Y N:N does not work either so it isn't the display vs return that is causing it)

If you try to change a couple or rows and press save you get the error, pastedImage_1.png

See here:

https://apex.oracle.com/pls/apex/f?p=88766:LOGIN::::::

GUEST/ Wordpass1!

Page 36

Regards

Mark Cary

Comments
Post Details
Added on Mar 12 2020
2 comments
587 views