|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Database updates but throws FRM-41032 error
Hello all,
I am a newbie and am modifying existing code. I made an enhancement but am now getting an error on a field that wasn't touched. The database updates fine but the FRM-41032 error is "Cannot set UPDATE ALLOWED of non-enabled item DB_BUDGET.FISCALYEAR. Any help is appreciated and code follows: declare errnumber number ; begin arameter.modified := 'Y' ;set_item_property('btnsave', enabled, property_true) ; set_item_property('btnsave', navigable, property_true) ; set_item_property('query', enabled, property_false) ; set_item_property('yearly_budget', enabled, property_true) ; set_item_property('yearly_budget', navigable, property_true) ; set_item_property('reserve_amount', enabled, property_true) ; set_item_property('reserve_amount', navigable, property_true) ; set_item_property('budget_amount', enabled, property_true) ; set_item_property('budget_amount', navigable, property_true) ; set_item_property('first_record', enabled, property_true) ; set_item_property('last_record', enabled, property_true) ; set_item_property('previous_record', enabled, property_true) ; set_item_property('next_record', enabled, property_true) ; set_item_property('first_record', navigable, property_true) ; set_item_property('last_record', navigable, property_true) ; set_item_property('previous_record', navigable, property_true) ; set_item_property('next_record', navigable, property_true) ; set_item_property('fiscalyear', update_allowed, property_true) ; set_item_property('yearly_budget', update_allowed, property_true) ; set_item_property('reserve_amount', update_allowed, property_true) ; set_item_property('budget_amount', update_allowed, property_true) ; go_block('db_budget') ; go_item('yearly_budget') ; set_item_property('btnmodify', enabled, property_false) ; set_item_property('btndelete', enabled, property_false) ; set_item_property('btnprint', enabled, property_false) ; exception when others then set_alert_property('erralert', alert_message_text, 'testing') ; errnumber := show_alert('erralert') ; message(sqlerrm) ; end ; |
|
#2
|
|||
|
|||
|
FRM-41032 error generated from the form and not database
Actually I wanted to clarify my previous post. The data is reaching the database fine. The form that is being updated (after using the modify button) is what is generating the error.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Database updates but throws FRM-41032 error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|