From: jomarlen@aol.com (Jomarlen) Subject: Re: Set_Item_property : Displayed Date: 1997/10/10 Message-ID: <19971010232900.TAA14520@ladder01.news.aol.com> References: <01bcd534$ac31ece0$8a14e68b@jo5141-h.fste.stu.cowan.edu.au> X-Admin: news@aol.com Organization: AOL http://www.aol.com Newsgroups: comp.databases.oracle.misc Hi At the risk of sounding churlish, I believe people should check out the manual and/or on-line help before posting. Having got that off my chest, below is what the manual says. Below that is a package I use for setting enabled/disabled properties which could be adapted for displayed/not dispalyed items properties. John ENABLED False ·sets the Navigable item property to False ·sets the Update_NULL item property to False ·sets Updateable to False ·sets the Required item property to False DISPLAYED False ·sets the Enabled and Navigable item properties to False ·sets Updateable to False ·sets the Update_NULL item property to False ·sets the Required item property to False ·sets the Queryable item property to False UPDATEABLE True ·sets the Update_NULL item property to False UPDATE_NULL True ·sets the Updateable item property to False PACKAGE Form_Item IS ---------------------------------------------------------------------------- PROCEDURE Disable_Item (p_Disable_Item IN VARCHAR2); ---------------------------------------------------------------------------- PROCEDURE Enable_Item(p_Enabled_Item IN VARCHAR2 ,p_Navigable IN BOOLEAN DEFAULT TRUE ,p_Required IN BOOLEAN DEFAULT TRUE ,p_Updateable IN BOOLEAN DEFAULT TRUE ,p_Update_Null IN BOOLEAN DEFAULT FALSE ); ----------------------------------------------------------------------------- END; PACKAGE BODY Form_Item IS ------------------------------------------------------------------ PROCEDURE Disable_Item (p_Disable_Item IN VARCHAR2) IS It_Id ITEM; BEGIN It_Id := Find_Item(p_Disable_Item); IF NOT Id_Null(It_Id) THEN Set_Item_Property (p_Disable_Item ,ENABLED ,Property_False); END IF; END; -------------------------------------------------------------------- PROCEDURE Enable_Item(p_Enable_Item IN VARCHAR2 ,p_Navigable IN BOOLEAN DEFAULT TRUE ,p_Required IN BOOLEAN DEFAULT TRUE ,p_Updateable IN BOOLEAN DEFAULT TRUE ,p_Update_Null IN BOOLEAN DEFAULT FALSE ) IS t_Item_Id item; BEGIN t_Item_Id := Find_Item(p_Enable_Item); /* ** Set item property enabled TRUE */ IF NOT Id_Null(t_Item_Id) THEN Set_Item_Property(p_Enable_item ,ENABLED ,PROPERTY_TRUE); /* ** Set item property navigable */ IF p_Navigable THEN Set_Item_Property(p_Enable_item ,NAVIGABLE ,PROPERTY_TRUE); ELSE Set_Item_Property(p_Enable_item ,NAVIGABLE ,PROPERTY_FALSE); END IF; /* ** Set item property updateable */ IF p_Updateable THEN Set_Item_Property(p_Enable_item ,UPDATEABLE ,PROPERTY_TRUE); ELSIF p_Update_Null THEN Set_Item_Property(p_Enable_item ,UPDATE_NULL ,PROPERTY_TRUE); END IF; /* ** Set item property required */ IF p_Required AND (p_Updateable OR p_Update_Null) THEN Set_Item_Property(p_Enable_item ,REQUIRED ,PROPERTY_TRUE); ELSE Set_Item_Property(p_Enable_item ,REQUIRED ,PROPERTY_FALSE); END IF; END IF; END; ------------------------------------------------------ END Form_Item; ------------------------------------------------------- John C. Lennon Utility Partners Inc. 4300 West Tropicana Blvd LVO-UPL Las Vegas NV 89103 FOR UTILITY PARTNERS EMPLOYMENT OPPORTUNITIES VISIT www.utilpart.com e-mail: jomarlen@aol.com Web Site: http://members.aol.com/jomarlen/ The views expressed in this message are those of the author and not necessarily those of U.P. Inc. and/or its employees. ------------------------------------------------------- >Subject: Set_Item_property : Displayed >From: "Ben Carter" >Date: Fri, Oct 10, 1997 00:23 EDT >Message-id: <01bcd534$ac31ece0$8a14e68b@jo5141-h.fste.stu.cowan.edu.au> > >Hi, > I was just looking for some advice and help regarding items when you set >their displayed property to off, what other properties are actually >changed, and why they are not reset when you enable the displayed property. > > I would appreciate all help regarding this mater and possibly a way around >having to set each property back manually. > > Im running Oracle v7, Designing using Forms v4.5.7.0.10 and PL/SQL >v1.2.1.3.0 > > Thanks in advance for all advice, and responses would be prefered by >e-mail. > >Ben Carter > > > > > > >