| form error [message #378669] |
Wed, 31 December 2008 04:40  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
