Home » Developer & Programmer » Forms » Problem in Form Update (6i)
Problem in Form Update [message #377681] Wed, 24 December 2008 04:02 Go to next message
rakhatmis
Messages: 25
Registered: March 2008
Junior Member
Hi experts

I am using forms 6i. I have a form where I am working on some DMLs. The form is working fine for insert, save and delete. I have created the data block using the data block wizard.
My problem is that when I search for a specific record using "select" statement, the record retrieved successfully but the error "FRM-40509:Oracle error:unable to UPDATE record" raises when I do some modifications and press save.
On "display error" the error is
"ORA-00001: unique constraint (SCOTT.PI_EMPLOYEEID_PK)violated"
Kindly suggest me regarding this problem ASAP
Thanking You in advance

Re: Problem in Form Update [message #377705 is a reply to message #377681] Wed, 24 December 2008 07:25 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
My problem is that when I search for a specific record using "select" statement

Right, that is the main problem. You do not search for a specific record using SELECT statement, but use Forms built-in search engine: enter the ENTER-QUERY mode, enter search criteria, EXECUTE-QUERY.

Because, although you have thought that you are updating a record, you were wrong: you were inserting a record same as the existing one (probably not entirely the same, but primary key columns were exactly the same). That's useless; give it up. Use ENTER/EXECUTE-QUERY instead.
Re: Problem in Form Update [message #377850 is a reply to message #377705] Thu, 25 December 2008 22:54 Go to previous message
rakhatmis
Messages: 25
Registered: March 2008
Junior Member
Thanks for your timely help.
My problem has been solved by your suggestion.
Thank you
Previous Topic: modifying oracle JAR files
Next Topic: Retrieving records
Goto Forum:
  


Current Time: Sun Dec 04 17:06:31 CST 2016

Total time taken to generate the page: 0.09277 seconds