OraFAQ Forum: Forms » Help me with FRM-40509(Unable to Update record) mistake

Home » Developer & Programmer » Forms » Help me with FRM-40509(Unable to Update record) mistake

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help me with FRM-40509(Unable to Update record) mistake [message #192586]

Tue, 12 September 2006 22:46

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.

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

sandeepk7
Messages: 137
Registered: September 2006

Senior Member

is there any update trigger on table?

Report message to a moderator

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

nhom9a
Messages: 51
Registered: July 2005
Location: VN

Member

No. I don't have any trigger on this table.

Report message to a moderator

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

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

Report message to a moderator

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

nhom9a
Messages: 51
Registered: July 2005
Location: VN

Member

it runs good now.
thanhks

Report message to a moderator

Previous Topic:	Oracle Forms
Next Topic:	set_item_property problem...urgent plsss....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 16:02:11 CST 2025