set_item_property

How to set Item property in oracle forms builder?

You can easily set Item’s property of different items in form builder. For restrict Insert/Update in item: SET_ITEM_PROPERTY(‘TRANS_ID’,INSERT_ALLOWED,PROPERTY_FALSE); SET_ITEM_PROPERTY(‘TRANS_ID’,UPDATE_ALLOWED,PROPERTY_FALSE); For set required property No in item: SET_ITEM_PROPERTY(‘TRANS_ID’,REQUIRED,PROPERTY_FALSE); For set Enabled/Disabled item: SET_ITEM_PROPERTY(‘TRANS_ID’,ENABLED,PROPERTY_FALSE); For any color to Item: Set_Item_Instance_Property( ‘TRANS_ID’, CURRENT_RECORD,VISUAL_ATTRIBUTE,’VISUAL_ATTRIBUTE_NAME’);