OraFAQ Forum: Forms » how can update primary key in master and details

Home » Developer & Programmer » Forms » how can update primary key in master and details

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

how can update primary key in master and details [message #508248]

Fri, 20 May 2011 01:30

swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai

Member

Hi

I have a form which consist of three form

one is master and other are details

I take one value at master level in primary key at starting point at entry, which is passed to details table

i want to update value of primary key at the last save level

but erro fired child reocrd found

please help me

swapnil

Report message to a moderator

Re: how can update primary key in master and details [message #508249 is a reply to message #508248]

Fri, 20 May 2011 01:32

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You should not have to update primary key.
If you have to do it then your design is wrong and should be reviewed.

If you want to do this, you have to first disable the constraints (FK and PK).

Regards
Michel

Report message to a moderator

Re: how can update primary key in master and details [message #508254 is a reply to message #508249]

Fri, 20 May 2011 01:38

swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai

Member

Dear Mechel

Thank for reply

but listen i put some value from another table like sequence value which is entirly diffrent from my header table
at save i replaced it with other value which is possible

Report message to a moderator

Re: how can update primary key in master and details [message #508276 is a reply to message #508254]

Fri, 20 May 2011 02:39

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

You need to explain that in more detail.

Report message to a moderator

Previous Topic:	Setting date formats
Next Topic:	about button on LOV - Oracle Forms 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 15:36:49 CDT 2024