Total Pageviews

Sunday, July 30, 2023

Code of Items hide/visible by Push Button in Oracle Forms

Trigger of Push Button WHEN-BUTTON-PRESSED and WHEN-WINDOW-ACTIVATED at form level.

declare

m_label varchar2(30);

begin

m_label:=Get_Item_Property('control.filter' ,label);

if m_label = '- Filter' then

set_item_property('control.state',visible,property_false);

set_item_property('control.city',visible,property_false);

set_item_property('control.from_date',visible,property_false);

set_item_property('control.to_date',visible,property_false);

set_item_property('control.filter',label,'+ Filter');

else

set_item_property('control.state',visible,property_true);

set_item_property('control.city',visible,property_true);

set_item_property('control.from_date',visible,property_true);

set_item_property('control.to_date',visible,property_true);

set_item_property('control.filter',label,'- Filter');

end if;

end; 

No comments:

Post a Comment

ORA-00845: MEMORY_TARGET not supported on this system

 The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: SQL> sh...