OraFAQ Forum: Forms » save button problem..(insert into.....)

Home » Developer & Programmer » Forms » save button problem..(insert into.....)

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

save button problem..(insert into.....) [message #162658]

Sun, 12 March 2006 22:01

tanskiee
Messages: 3
Registered: March 2006
Location: Manila

Junior Member

guys im having an error frm-40508 oracle error unable to insert

INSERT INTO library_t VALUES(:xstudent_id, :xviolation, :xdate_due, :xdate_rent, 
					:xamount, :xlib_status, :xdescription);
COMMIT;

i also tried this

INSERT INTO library_t (student_id, violation, date_due, date_rent,
			amount,lib_status,description)
VALUES(:xstudent_id, :xviolation, :xdate_due, :xdate_rent, 
					:xamount, :xlib_status, :xdescription);
COMMIT;

anyone knows why?

Report message to a moderator

Re: save button problem..(insert into.....) [message #162686 is a reply to message #162658]

Mon, 13 March 2006 01:15

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

Senior Member
Account Moderator

Go to Help menu and select "Display Error" - in there you should be able to read a more descriptive ORA- message (for example, you are trying to insert NULL value into the NOT NULL column, or you have been granted SELECT and UPDATE but trying to perform INSERT action on the table, etc.).

Report message to a moderator

Re: save button problem..(insert into.....) [message #162882 is a reply to message #162658]

Mon, 13 March 2006 23:57

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

Senior Member
Account Moderator

ALWAYS write your variables as ':blk.itm'. There is a possibilty that Forms is using the 'right' item but from the 'wrong' block.

David

Report message to a moderator

Previous Topic:	Bypass Log-in Screen in Forms 6i
Next Topic:	Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:20:12 CDT 2024