OraFAQ Forum: Forms » from-40509 unable to update record

Home » Developer & Programmer » Forms » from-40509 unable to update record (form 6i oracle 8i )

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

from-40509 unable to update record [message #455271]

Mon, 10 May 2010 22:41

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

I have modified an existing form which is from 4 tables. I altered one of the table to suit my requirement and have compiled the form . It is compiled with out any errors. But when i enter any data it shows an error "frm-40509 --Unable to update record" and does not gets saved.

Could some one let me know what would be the problem

Report message to a moderator

Re: from-40509 unable to update record [message #455283 is a reply to message #455271]

Mon, 10 May 2010 23:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What did you change in the table? Did you make something 'not nullable'? Just because you recompiled the form doesn't mean that the characteristics of the item in the form have been changed. The database characteristics are only used during the initial build of the item/block/form.

David

Report message to a moderator

Re: from-40509 unable to update record [message #455292 is a reply to message #455283]

Tue, 11 May 2010 00:11

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps you could also go to Help menu - Display Error and see what really caused that error.

Report message to a moderator

Re: from-40509 unable to update record [message #455773 is a reply to message #455292]

Wed, 12 May 2010 23:17

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi,

i did see the help and it says that contact your DBA and the full rights might have not be given to me.

I wish to say that there are no DBA in our office and have full rights and we do all the work ourselves with the help of friends and other sources.

What did you change in the table? Did you make something 'not nullable'? Just because you recompiled the form doesn't mean that the characteristics of the item in the form have been changed. The database characteristics are only used during the initial build of the item/block/form.

i did add 3 column to the existing table and none are "not nullable"

Report message to a moderator

Re: from-40509 unable to update record [message #455784 is a reply to message #455773]

Thu, 13 May 2010 00:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Are you receiving any other error messages? Did you do a Ctrl-Shft-k (Compiel all) and a Ctrl-t (generate) to your form?

David

Report message to a moderator

Re: from-40509 unable to update record [message #455790 is a reply to message #455773]

Thu, 13 May 2010 00:54

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

lacchhii wrote on Thu, 13 May 2010 06:17

i did see the help and it says that contact your DBA and the full rights might have not be given to me.

Would you mind to post the exact error message and its code?

Report message to a moderator

Re: from-40509 unable to update record [message #455830 is a reply to message #455790]

Thu, 13 May 2010 02:53

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

this is the error message i received. I did compiled with ctrl +shift+k and ctrl+t and ctrl+s to compile and save

FRM-40509: ORACLE error: unable to UPDATE record.

Cause: A fatal error occurred while trying to update a record. The table associated with the current block of the form might not exist, your user name might not have authority to perform the specified action on the table, or some other reason might have caused the fatal error.

Action: Contact your DBA.

Level: >25

Type: Error

Report message to a moderator

Re: from-40509 unable to update record [message #455834 is a reply to message #455830]

Thu, 13 May 2010 03:09

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sorry, I wasn't specific enough. I was thinking about the error you saw when you chose Help - Display Error. It was, probably, something like "UPDATE table_name SET ..." along with, for example, "ORA-001400".

Report message to a moderator

Re: from-40509 unable to update record [message #455846 is a reply to message #455834]

Thu, 13 May 2010 03:29

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

its ok. there is no error of this type.
((something like "UPDATE table_name SET ..." along with, for example, "ORA-001400". ))

its get compiled and it accepts data entry but does not gets saved

Report message to a moderator

Re: from-40509 unable to update record [message #455867 is a reply to message #455846]

Thu, 13 May 2010 04:06

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

But, *something* is responsible for "ORACLE error: unable to UPDATE record.".

Report message to a moderator

Re: from-40509 unable to update record [message #455878 is a reply to message #455867]

Thu, 13 May 2010 04:34

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

I think you are mis-understanding Littlefoot.
We're not interested in what form builder help says, we know what it says.
Do the following:
1) Run the form.
2) Update a record.
3) When you get the FRM-40509 click on help in the menu bar at the top of the screen.
4) Select display error from the drop down menu.
5) A pop-up window will appear with the update statement forms issued to the DB along with an error message.
6) Copy and paste the contents of that pop-up window here.

Report message to a moderator

Previous Topic:	FORMS WITH JAVA (NOT JINIT)
Next Topic:	Need help on Forms Customization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:43:56 CDT 2024