Home » Developer & Programmer » Forms » not able to insert record
not able to insert record [message #216532] Mon, 29 January 2007 04:36 Go to next message
oracle06
Messages: 36
Registered: December 2005
Member
Hello All,
I am getting frm-40508 unable to insert record,on pressing shift + F1 I am getting database error ora-00001:unique constarint(name of the key)violated.
actually I am inserting two records with type P and A if I delete the record of type p and again i insert the record then it tries to insert in type A also then it gives above error.
and not saving the records.

for solving this i used on-insert trigger,I have written insert_record in this trigger now it is saving but before saving it is giving same error.

how to solve this.

please guide asap

thanks.
Re: not able to insert record [message #216583 is a reply to message #216532] Mon, 29 January 2007 09:41 Go to previous messageGo to next message
oracle06
Messages: 36
Registered: December 2005
Member
please reply how to handle this error.
Re: not able to insert record [message #216611 is a reply to message #216583] Mon, 29 January 2007 12:29 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Simply, don't insert a record which has the same combination of values in primary key constraint columns as the one that already exists in a table. The same goes for update.
Previous Topic: Need a modal dilaog to show up at (0,0)..ASAP
Next Topic: calendar development
Goto Forum:
  


Current Time: Fri Dec 02 22:47:49 CST 2016

Total time taken to generate the page: 0.08326 seconds