Home » Developer & Programmer » Forms » Unable to insert Record [FRM-40508] (Developer 6i, Oracle 9i, Windows Xp/Windows 2003)
Unable to insert Record [FRM-40508] [message #326715] Thu, 12 June 2008 06:46 Go to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Hello,
I have got an update form, where only the selected records will be be updated from the grid. But when i wanted to update those reocrds i am getting the error message FRM-40508, Try to solve but failed so far. So will someone please help me to get rid of this problem? Thanks in advance. For better understanding i am attatching the .fmb file. The table is like following:

CREATE TABLE PBL_DO.MASTER_SALES2
(
DO_NO VARCHAR2(17) NOT NULL,
DO_DATE DATE NOT NULL,
MRR_NO VARCHAR2(17) NOT NULL,
MRR_DATE DATE NOT NULL,
ITEM_CODE VARCHAR2(10),
ITEM_GL_CODE VARCHAR2(17),
PARTY_CODE VARCHAR2(10),
PARTY_GL_CODE VARCHAR2(17),
ITEM_RATE NUMBER(10,2) NOT NULL,
ITEM_QUANTITY NUMBER(10,2) NOT NULL,
LOCATION_ID VARCHAR2(20),
STYPE_ID VARCHAR2(10),
SALES_AMOUNT NUMBER(12,2) NOT NULL,
SL_NO VARCHAR2(500),
PMT_MODE_ID VARCHAR2(10),
AGAINST_DONO VARCHAR2(17),
AGAINST_DODATE DATE,
USERNAME VARCHAR2(17),
REMARKS VARCHAR2(500),
GRAND_TOTAL NUMBER(12,2),
DEPO_CODE VARCHAR2(17) NOT NULL,
TOTAL NUMBER(12,2),
OTHER_CHARGE NUMBER(12,2),
VAT NUMBER(10,2),
DISCOUNT NUMBER(10,2)
)
  • Attachment: DO_UPDATE.fmb
    (Size: 140.00KB, Downloaded 277 times)
Re: Unable to insert Record [FRM-40508] [message #326871 is a reply to message #326715] Thu, 12 June 2008 22:27 Go to previous messageGo to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
Check and see if the type and size of the item in the data base is the same as that defined in the report. Even if any one item differs you will not be able to update.

Regards.

Alister
Re: Unable to insert Record [FRM-40508] [message #326875 is a reply to message #326715] Thu, 12 June 2008 22:47 Go to previous messageGo to next message
urnikhil
Messages: 42
Registered: March 2008
Member
The following might be the cause:

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

- Nik.

Re: Unable to insert Record [FRM-40508] [message #326950 is a reply to message #326715] Fri, 13 June 2008 03:00 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Re-run the form. Try to perform "save" - you'll get an error message.

Select Help menu - Display error. It will probably show an exact reason, associated with a an Oracle error code (such as ORA-01400).

See if you can figure it out. If not, post contents of the Display Error window back here.
Re: Unable to insert Record [FRM-40508] [message #327063 is a reply to message #326715] Fri, 13 June 2008 10:35 Go to previous messageGo to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Dear all,
Thanks for the reply. According to the advice given by you all i have checked it throughly but yet unable to solve the problem. As i gave already send the .fmb file now i am sending you the message i am receiving after pressing the button Update.So i hope this time i may get a solution of my problem. Again i would like to thanks everybody for considering my problem and spending time on it.

FRM-40508:ORACLE error:unable to INSERT record

Best Regards
Mahatab


Re: Unable to insert Record [FRM-40508] [message #327097 is a reply to message #327063] Fri, 13 June 2008 15:13 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why do you refuse to show us error? I told you to select Help menu - Display Error and post what's in there back here.

./fa/4443/0/

Re: Unable to insert Record [FRM-40508] [message #327115 is a reply to message #326715] Fri, 13 June 2008 23:42 Go to previous messageGo to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Hello,
I am sorry for the late reply. According to the instruction given by you i am attatching the error message generated when try to update the records:


./fa/4444/0/

Please try to help me to get rid of this problem.

Best Regards
Mahatab
Re: Unable to insert Record [FRM-40508] [message #327117 is a reply to message #327115] Fri, 13 June 2008 23:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
The message looks clear to me!
You have the query, you have the database and you have the error.
Now, go find out which column-name is invalid and fix.
Re: Unable to insert Record [FRM-40508] [message #327119 is a reply to message #326715] Sat, 14 June 2008 00:34 Go to previous messageGo to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Thanks Frank,
I have checked my Db and Query many times but I am sure i didn't use any Column Named RowID. So will you please advice me something else regarding my problem. I am really wonder from where that ROWID comes from???

Regards
Mahatab
Re: Unable to insert Record [FRM-40508] [message #327134 is a reply to message #327119] Sat, 14 June 2008 03:15 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you copy the sql from the pop-up and execute it in a sqlplus session?
What happened? (please copy-paste the execution here)

I would not worry so much about ROWID. It is a pseudo-column that does not need to be defined explicitly in your table.
However, are you sure that you have a column DONO as well as a column DO_NO?!
Re: Unable to insert Record [FRM-40508] [message #327207 is a reply to message #326715] Sat, 14 June 2008 23:38 Go to previous messageGo to next message
mahatab
Messages: 98
Registered: January 2008
Location: Dhaka
Member

Frank,
According to your advice i have execute the Pop Up error in SQL*Plus and the result that i have got is as follows:

SQL> SELECT ROWID,DO_NO,DO_DATE,MRR_NO,MRR_DATE,ITEM_CODE,PARTY_CODE,ITEM_RATE,SALES_AMOUNT,AGAINST_DONO,AGAINST_DODATE,GRAND_TOTAL,DEPO_CODE,ITE M_QUANTITY,CHECK_BOX FROM MASTER_SALES2;

SELECT ROWID,DO_NO,DO_DATE,MRR_NO,MRR_DATE,ITEM_CODE,PARTY_CODE,ITEM_RATE,SALES_AMOUNT,AGAINST_DONO,

ERROR at line 1:
ORA-00904: invalid column name

In addition i have changed the block of dono and DO_no seperately to avoid any further more problem(though there was no problem at all), Any way still i have got the same problem. So i need few more ideas/suggestions to overcome the problem.

Thank you All
Mahatab
Re: Unable to insert Record [FRM-40508] [message #327231 is a reply to message #327207] Sun, 15 June 2008 09:13 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Do you know the basics of Oracle and SQL?
Do you know how to see the structure of a table? Then it should not be so hard to see which column is in the query, but not in the table (check_box perhaps?)
WE cannot tell you, you are the only one with access to your table.
Previous Topic: Unnecessary message displayed: 'Do you want to save the changes you made?'
Next Topic: How to get the value of the item
Goto Forum:
  


Current Time: Fri Dec 09 13:13:43 CST 2016

Total time taken to generate the page: 0.29792 seconds