OraFAQ Forum: Forms » Problem in Form Update

Home » Developer & Programmer » Forms » Problem in Form Update (6i)

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

Problem in Form Update [message #377681]

Wed, 24 December 2008 04:02

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

Report message to a moderator

Re: Problem in Form Update [message #377705 is a reply to message #377681]

Wed, 24 December 2008 07:25

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Problem in Form Update [message #377850 is a reply to message #377705]

Thu, 25 December 2008 22:54

rakhatmis
Messages: 25
Registered: March 2008

Junior Member

Thanks for your timely help.
My problem has been solved by your suggestion.
Thank you

Report message to a moderator

Previous Topic:	modifying oracle JAR files
Next Topic:	Retrieving records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 18:11:08 CST 2025