OraFAQ Forum: Forms » DESPERATE: FRM-40508

Home » Developer & Programmer » Forms » DESPERATE: FRM-40508

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

DESPERATE: FRM-40508 [message #224374]

Wed, 14 March 2007 02:10

yesitsmkdp
Messages: 1
Registered: March 2007
Location: philippines

Junior Member

so im making a very simple system.. i made a form that accepts information.. it does the whole thing like add, delete, edit etc. and then i made another form thats supposed to accept infos as well but the damn thing wont work. i mean, i did the whole commit, update_record, create_record.. everything right. BUT the damn thing wont save records. what should i do?

the error is FRM-40508. the shift+f1 gives me this:

INSERT INTO MHCS_STUDINFO(LN,FN,MN,ADDRESS,PHONEA,BDAY,GENDER,LEVEL,FNAME,FOCC,MNAME,MOCC,ENAME,ADDRESSB,PHONEB) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)

ORA-01747: invalid user.table.column, table.column, or column specification

please help me. im really lost with this thing. thank you.

ym: yesitsmkdp@yahoo.com
msn: m3gz@hotmail.com

Report message to a moderator

Re: DESPERATE: FRM-40508 [message #224380 is a reply to message #224374]

Wed, 14 March 2007 02:21

aciolac
Messages: 242
Registered: February 2006

Senior Member

Possible that in the INSERT statement are not indicated owner of table. Try to verify this, and if it is correct, You can use public synonyms to correct error.

Report message to a moderator

Re: DESPERATE: FRM-40508 [message #224981 is a reply to message #224374]

Fri, 16 March 2007 06:28

Frank
Messages: 7901
Registered: March 2000

Senior Member

yesitsmkdp wrote on Wed, 14 March 2007 08:10

INSERT INTO MHCS_STUDINFO(LN,FN,MN,ADDRESS,PHONEA,BDAY,GENDER,LEVEL,FNAME,FOCC,MNAME,MOCC,ENAME,ADDRESSB,PHONEB) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)

LEVEL is a reserved word and should not be used as column name.

SQL> create table faq (id number, "LEVEL" number);

Table created.

SQL> insert into faq (id, level) values (1, 2);
insert into faq (id, level) values (1, 2)
                     *
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification

So better watch your language next time, because it is not the FORM that "won't work"...

Report message to a moderator

Previous Topic:	to save last record and exit loop
Next Topic:	Icons are not displaying at run time in 10G

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:44:12 CST 2024