Home » Developer & Programmer » Forms » form error (9i)
form error [message #378669] Wed, 31 December 2008 04:40 Go to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
i have database form and one of the column is active_indicator( Y OR N ) and i wrote procedure that when the active_indicator(list_item) change will effect (no delete,no insert) the other columns (CITY,SORT_SEQ)in the form.
the problem is when i try to change active_indicator from yes as defualt to no...the procedure is working fine and i can not insert, but when i change active_indicator from no to yes...i can not do that ..it keeps saying NO.
THIS IS THE PROCUDURE(WHEN-LIST-CHANGED)

IF :FYTRCTY_ACTIVE_IND = 'Y'
THEN
Set_Block_Property('FYTRCTY',UPDATE_ALLOWED,PROPERTY_TRUE);

ELSIF :FYTRCTY_ACTIVE_IND = 'N'
THEN
Set_Block_Property('FYTRCTY',UPDATE_ALLOWED,PROPERTY_FALSE);
END IF;

How can i solve this problem ?
Re: form error [message #378674 is a reply to message #378669] Wed, 31 December 2008 04:50 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what you've done:
- by default, active_indicator = Y
- then you change it to active_indicator = N. Doing so, you set block update_allowed property to false.
- it means that you can not update any item in this block, including active_indicator item as well
- now you tried to modify active_indicator, but you are not allowed to. Of course you are not!

Remedy: don't modify BLOCK property - use SET_ITEM_PROPERTY built-in instead.
Previous Topic: How to pass values of current record as parameters to next form?
Next Topic: How to sort values in columns.
Goto Forum:
  


Current Time: Wed Dec 07 14:43:44 CST 2016

Total time taken to generate the page: 0.06070 seconds