Switch Oracle Forms List of Values on and off dynamically at run time
In e.g. post-query block level trigger:
01 | IF block.check_field = 'F' |
02 | THEN |
03 | -- switch on |
04 | Set_Item_Property( 'block.field' , LOV_NAME, 'your lov' ) ; |
05 | Set_Item_Property( 'block.field' , VALIDATE_FROM_LIST, PROPERTY_TRUE); |
06 | ELSE |
07 | -- switch off |
08 | Set_Item_Property( 'block.field' , LOV_NAME, '' ) ; |
09 | Set_Item_Property( 'block.field' , VALIDATE_FROM_LIST, PROPERTY_FALSE); |
10 | END IF ; |
I was not able to implement switch off part in one of my forms, it helped me.
Thank you