Muhammad Khan
asked on
Stuck in Oracle Forms 6i (Set_item_property)
Dear Experts,
I know nothing about Oracle Forms 6i, and i have to design a form which will search from a database. I managed to do this.. now i am stuck at one place.
On a selection of a checkbox, i am hiding one set of items and displaying another on the same location (both sets are put on the same location with one of them's visible property set to false at design time)
I am using set_item_property to set the visible property to false or true.. I can query on the items when i run the form..
the problem is.. when i hide the items and display again.. they will be disabled.... i used enabled property to enable them.. but then they can't be used for query anymore.. means if i press F7 it won't let me go inside those items to query..
Following is my code at the checkbox...
any ideas?
I know nothing about Oracle Forms 6i, and i have to design a form which will search from a database. I managed to do this.. now i am stuck at one place.
On a selection of a checkbox, i am hiding one set of items and displaying another on the same location (both sets are put on the same location with one of them's visible property set to false at design time)
I am using set_item_property to set the visible property to false or true.. I can query on the items when i run the form..
the problem is.. when i hide the items and display again.. they will be disabled.... i used enabled property to enable them.. but then they can't be used for query anymore.. means if i press F7 it won't let me go inside those items to query..
Following is my code at the checkbox...
any ideas?
if :chkarabic=1 then
set_item_property('first_name_1',visible,property_false);
set_item_property('father_name_1',visible,property_false);
set_item_property('mid_name_1',visible,property_false);
set_item_property('last_name_1',visible,property_false);
set_item_property('first_name_s_1',visible,property_true);
set_item_property('father_name_s_1',visible,property_true);
set_item_property('mid_name_s_1',visible,property_true);
set_item_property('last_name_s_1',visible,property_true);
set_item_property('first_name_s_1',enabled,property_true);
set_item_property('father_name_s_1',enabled,property_true);
set_item_property('mid_name_s_1',enabled,property_true);
set_item_property('last_name_s_1',enabled,property_true);
-- set_item_property('first_name_s_1',QUERY_ALLOWED,property_true);
--set_item_property('father_name_s_1',query_allowed,property_true);
--set_item_property('mid_name_s_1',query_allowed,property_true);
--set_item_property('last_name_s_1',query_allowed,property_true);
--set_item_property('frame55',label,'Arabic Names');
message('arabic');
else
set_item_property('first_name_1',visible,property_true);
set_item_property('father_name_1',visible,property_true);
set_item_property('mid_name_1',visible,property_true);
set_item_property('last_name_1',visible,property_true);
set_item_property('first_name_1',enabled,property_true);
set_item_property('father_name_1',enabled,property_true);
set_item_property('mid_name_1',enabled,property_true);
set_item_property('last_name_1',enabled,property_true);
--set_item_property('frame55',label,'Englisn Names');
set_item_property('first_name_s_1',visible,property_false);
set_item_property('father_name_s_1',visible,property_false);
set_item_property('mid_name_s_1',visible,property_false);
set_item_property('last_name_s_1',visible,property_false);
-- set_item_property('first_name_1',query_allowed,property_true);
--set_item_property('father_name_1',query_allowed,property_true);
--set_item_property('mid_name_1',query_allowed,property_true);
--set_item_property('last_name_1',query_allowed,property_true);
message('English');
end if;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
errm, its just the same as OMC2000 advice, sorry for rephrasing :-(
ASKER
I changed my form's design... thanks anyways
SET_ITEM_PROPERTY(item_nam
SET_ITEM_PROPERTY(item_nam
SET_ITEM_PROPERTY(item_nam
meikl ;-)