Home » Developer & Programmer » Forms » Help me with FRM-40509(Unable to Update record) mistake
Help me with FRM-40509(Unable to Update record) mistake [message #192586] Tue, 12 September 2006 22:46 Go to next message
nhom9a
Messages: 51
Registered: July 2005
Location: VN
Member
Hi all.
I have one table with name Function_right(function_id,function_name,description,user_id,visible_invisible)
I onle want to update "visible_invisible" column.
I have created form layout with block function_right,
I have chosen update changed column only is yes for block and all column except "visible_invisible" with update allowed is No.

I have a button with code:
update function_right set visible_invisible=:function_right.visible_invisible where user_id=:users.user_id and function_id=:function_right.function_id;
COMMIT;

When I press this button I get a mistake FRM-40509 Oracle error Unable to Update record.

anybody help me ?
thanks.
Re: Help me with FRM-40509(Unable to Update record) mistake [message #192592 is a reply to message #192586] Tue, 12 September 2006 23:14 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

You do not need to write

*****************************************************
update function_right set visible_invisible=:function_right.visible_invisible where user_id=:users.user_id and function_id=:function_right.function_id;
COMMIT;
******************************************************

use commit_form to save changes.

Sandy
icon5.gif  Re: Help me with FRM-40509(Unable to Update record) mistake [message #192594 is a reply to message #192586] Tue, 12 September 2006 23:24 Go to previous messageGo to next message
nhom9a
Messages: 51
Registered: July 2005
Location: VN
Member
Thanks Sandy.
I've already tried to use commit_form. But I also received this error.
Re: Help me with FRM-40509(Unable to Update record) mistake [message #192596 is a reply to message #192594] Tue, 12 September 2006 23:27 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

is there any update trigger on table?
Re: Help me with FRM-40509(Unable to Update record) mistake [message #192600 is a reply to message #192586] Tue, 12 September 2006 23:36 Go to previous messageGo to next message
nhom9a
Messages: 51
Registered: July 2005
Location: VN
Member
No. I don't have any trigger on this table.
Re: Help me with FRM-40509(Unable to Update record) mistake [message #192611 is a reply to message #192586] Wed, 13 September 2006 00:21 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

ok,
when getting "FRM-40509 Oracle error Unable to Update record."
Press Shift+F1 to see what exactly worng with this query. Send this Error message.

Sandy
Re: Help me with FRM-40509(Unable to Update record) mistake [message #192628 is a reply to message #192586] Wed, 13 September 2006 01:21 Go to previous message
nhom9a
Messages: 51
Registered: July 2005
Location: VN
Member
it runs good now.
thanhks
Previous Topic: Oracle Forms
Next Topic: set_item_property problem...urgent plsss....
Goto Forum:
  


Current Time: Thu Dec 08 10:15:28 CST 2016

Total time taken to generate the page: 0.13041 seconds