 from-40509 unable to update record [message #455271] |
Mon, 10 May 2010 22:41  |
|
|
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
|
|
|
|
|
|
|
|
| Re: from-40509 unable to update record [message #455773 is a reply to message #455292] |
Wed, 12 May 2010 23:17  |
|
|
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"
|
|
|
|
|
|
|
|
| Re: from-40509 unable to update record [message #455830 is a reply to message #455790] |
Thu, 13 May 2010 02:53 |
|
|
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
|
|
|
|
|
|
|
|
|
|
| Re: from-40509 unable to update record [message #455878 is a reply to message #455867] |
Thu, 13 May 2010 04:34 |
cookiemonster
Messages: 13966
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
