Home » Developer & Programmer » Forms » how to remove LOV form item on runtime
how to remove LOV form item on runtime [message #346193] Sun, 07 September 2008 03:41 Go to next message
tarekfathi2003
Messages: 23
Registered: August 2008
Location: kw
Junior Member
dear firends
i have a problem
i a tabular block.
the item "element_value' could have free writen value or sometimes reistrected values
if the value in :DETAIL.UVLS_ID is not null then a LOV is attchaed to the item"element_value" on runtime so that user select a avlaue from LOV.
this code fire on WHEN-NEW-RECORD-INSTANCE
BEGIN
:DETAIL.UVLS_ID := RSK_GET_PKG.F_GET_ELM_VLS(P_ELM_ID);
IF :DETAIL.UVLS_ID IS NOT NULL THEN
SET_ITEM_PROPERTY('DETAIL.ELEMENT_VALUE',LOV_NAME,'CG$VALUESETDETAIL');
Else
-- SET_ITEM_PROPERTY('DETAIL.ELEMENT_VALUE',LOV_NAME,'NULL');
null;
END IF;
END;
my problem is
i want to remove the LOV from the item"element_value" incase the
:DETAIL.UVLS_ID is null.
how can i do that
please help
Re: how to remove LOV form item on runtime [message #346236 is a reply to message #346193] Sun, 07 September 2008 21:33 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try "SET_ITEM_PROPERTY('DETAIL.ELEMENT_VALUE',LOV_NAME,'');"

David
Re: how to remove LOV form item on runtime [message #346282 is a reply to message #346193] Mon, 08 September 2008 01:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Tarek,

Please read the forum guidelines at http://www.orafaq.com/forum/t/88153/0/ with specific attention to the use of punctuation and the spelling checker. Use them and it will be easier to read your entry and you will get a higher rate of responses. Forget the colour but please use the 'code' tags.

David
Re: how to remove LOV form item on runtime [message #346369 is a reply to message #346282] Mon, 08 September 2008 06:31 Go to previous message
tarekfathi2003
Messages: 23
Registered: August 2008
Location: kw
Junior Member
thanks for your advice
the code works fine
thanks again
Previous Topic: Regarding Calender
Next Topic: Keyboard Mapping
Goto Forum:
  


Current Time: Mon Dec 05 06:40:36 CST 2016

Total time taken to generate the page: 0.08360 seconds