Solved

Stuck in Oracle Forms 6i (Set_item_property)

Posted on 2008-06-22
4
20,688 Views
Last Modified: 2013-12-07
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
Comment
Question by:aiklamha
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
OMC2000 earned 500 total points
ID: 21841167
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 21843823
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 21843835
errm, its just the same as OMC2000 advice, sorry for rephrasing :-(
0
 
LVL 17

Author Comment

by:aiklamha
ID: 22144440
I changed my form's design... thanks anyways
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now