Switch Oracle Forms List of Values on and off dynamically at run time

In e.g. post-query block level trigger:

IF block.check_field = 'F'
THEN
   -- switch on
   Set_Item_Property( 'block.field' , LOV_NAME, 'your lov') ;
   Set_Item_Property( 'block.field', VALIDATE_FROM_LIST, PROPERTY_TRUE);
ELSE
   -- switch off
   Set_Item_Property( 'block.field' , LOV_NAME, '') ;
   Set_Item_Property( 'block.field', VALIDATE_FROM_LIST, PROPERTY_FALSE);
END IF ;

H/t Fran├žois Degrelle

Posted in Oracle forms
2 comments on “Switch Oracle Forms List of Values on and off dynamically at run time
  1. Anjan Bagchi says:

    I was not able to implement switch off part in one of my forms, it helped me.
    Thank you ­čÖé

  2. VAHID says:

    Hi Andrew
    I am Vahid
    Thanks for this excelent example.

Leave a Reply

Your email address will not be published. Required fields are marked *

*