OraFAQ Forum: Forms » design error

Home » Developer & Programmer » Forms » design error

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

design error [message #143606]

Fri, 21 October 2005 03:59

fmis
Messages: 11
Registered: October 2005
Location: CALICUT

Junior Member

when iam designing a form an error occoured ie.frm-40735 and ora-02291 .please advise to tackle this error.

Report message to a moderator

Re: design error [message #143639 is a reply to message #143606]

Fri, 21 October 2005 05:54

Maaher
Messages: 7065
Registered: December 2001

Senior Member

	ORA-02291 integrity constraint (string.string) violated - parent key not found


Cause: A foreign key value has no matching primary key value.

Action: Delete the foreign key or add a matching primary key.

you are inserting/updating in your detail table without having a corresponding record in the parent table.

MHE

Report message to a moderator

Re: design error [message #143876 is a reply to message #143639]

Sun, 23 October 2005 23:01

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

Senior Member
Account Moderator

When you are creating a master/detail form use the 'relations' wizard to help you 'join' the two blocks.

David

Report message to a moderator

Re: design error [message #143899 is a reply to message #143639]

Mon, 24 October 2005 00:37

fmis
Messages: 11
Registered: October 2005
Location: CALICUT

Junior Member

dear maheer,
Thanks for giving a valueable inforamtion.
I had corrected my form by useing a 'post' command when leaving the first block.

Report message to a moderator

Previous Topic:	Checkboxes being ticked by default when they shouldn't be
Next Topic:	Copying menu without closing User Sessions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:31:50 CDT 2024