Home » Developer & Programmer » Forms » Set_item_property (Forms 6i)
Set_item_property [message #528409] Mon, 24 October 2011 14:08 Go to next message
Hometown
Messages: 35
Registered: October 2010
Location: India
Member
I want to check a value in a text field and if the condition is satisfied then set item's property of the next text item for e.g
if :tbl_category_detail.category_amount = 100 then
set_item_property('tbl_donation.purpose_name','MNA')


please note the text item purpose_name has LOV (List of value associated with it)and MNA is among the one in the list which retrieves data from the underlying record group
How do I achieve this.

Regards
Re: Set_item_property [message #528412 is a reply to message #528409] Mon, 24 October 2011 14:37 Go to previous messageGo to next message
Littlefoot
Messages: 21817
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a WHEN-VALIDATE-ITEM trigger on "category_amount" item and put your code in there. SET_ITEM_INSTANCE built-in is described in Forms' Help (in there you'll find how to deal with LoV). I'm not sure I understood what 'MNA' has to do with the issue.
Re: Set_item_property [message #528470 is a reply to message #528412] Tue, 25 October 2011 03:43 Go to previous message
cookiemonster
Messages: 13931
Registered: September 2008
Location: Rainy Manchester
Senior Member
Seems you want to assign a value to the item, not change one of it's properties. In which case:
IF :tbl_category_detail.category_amount = 100 THEN
  :tbl_donation.purpose_name := 'MNA';
END IF;
Previous Topic: Updating a Record through Form
Next Topic: Oracle form's support for Persian (Farsi) characters.
Goto Forum:
  


Current Time: Sun Aug 11 08:51:17 CDT 2024