Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 23443
  • Last Modified:

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?

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;

Open in new window

0
Muhammad Khan
Asked:
Muhammad Khan
  • 2
1 Solution
 
OMC2000Commented:
try these properties setting for your form items:
set_item_property (item_name, navigable, property_true);
set_item_property (item_name, update_allowed, property_true);
0
 
kretzschmarCommented:
try these settings additional after making it visible

SET_ITEM_PROPERTY(item_name, ENABLED   , PROPERTY_TRUE);
SET_ITEM_PROPERTY(item_name, NAVIGABLE , PROPERTY_TRUE);
SET_ITEM_PROPERTY(item_name, UPDATEABLE, PROPERTY_TRUE);

meikl ;-)
0
 
kretzschmarCommented:
errm, its just the same as OMC2000 advice, sorry for rephrasing :-(
0
 
Muhammad KhanManager, ITAuthor Commented:
I changed my form's design... thanks anyways
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now