OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » update

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

update [message #148288]

Wed, 23 November 2005 07:37

seyiisq
Messages: 125
Registered: September 2005

Senior Member

i have a lot of record in a particular form. If i retrieve a record from this form using LOV and try to update i keep getting an error message of primary key constraint violated. but if a execute query and navigate to that particular record to update it, the record will be updated.

I need to by able to update after using the LOV to retrieve record.

can you advice

Report message to a moderator

Re: update [message #148580 is a reply to message #148288]

Fri, 25 November 2005 02:59

pallavig
Messages: 18
Registered: November 2005

Junior Member

Are you doing through wizard or manually??

Pal

Report message to a moderator

Re: update [message #148607 is a reply to message #148580]

Fri, 25 November 2005 05:03

seyiisq
Messages: 125
Registered: September 2005

Senior Member

i am doing it through wizard

Report message to a moderator

Re: update [message #148913 is a reply to message #148607]

Tue, 29 November 2005 00:40

pallavig
Messages: 18
Registered: November 2005

Junior Member

No Message Body

[Updated on: Tue, 29 November 2005 00:40]

Report message to a moderator

Re: update [message #150040 is a reply to message #148288]

Tue, 06 December 2005 01:32

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

Senior Member
Account Moderator

What is the code that you are using to populate the primary key? Please check that you are not repopulating your already populated primary key when you use the LOV.

David

Report message to a moderator

Previous Topic:	Please Help
Next Topic:	using 'text_io'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:38:52 CDT 2024