OraFAQ Forum: Forms » problem with master detail

Home » Developer & Programmer » Forms » problem with master detail

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

problem with master detail [message #682024]

Sun, 27 September 2020 15:23

compuscience
Messages: 97
Registered: September 2012

Member

i create master detail in oracle forms 6i
it worked perfectly when inserting for first time
but the problem is when update field in master not affect in detail
may i get help please

Report message to a moderator

Re: problem with master detail [message #682025 is a reply to message #682024]

Sun, 27 September 2020 15:45

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What exactly isn't affected? Master-detail blocks have relationship which relies on master's primary key column which is referenced by detail block's foreign key constraint column.

If you are saying that you're modifying master's primary key column, then think twice: is it smart to do so? As far as I can tell, that's usually (if not always) a really bad idea.

Report message to a moderator

Re: problem with master detail [message #682027 is a reply to message #682025]

Sun, 27 September 2020 15:51

compuscience
Messages: 97
Registered: September 2012

Member

then you say that i must made primary key right or link between columns only

Report message to a moderator

Re: problem with master detail [message #682031 is a reply to message #682027]

Mon, 28 September 2020 02:34

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Ideally, data model should be set right. Primary keys + foreign keys (as far as master-detail relationship is concerned). In that case, Data Block Wizard is capable of determining that relationship out of data dictionary and sets everything right. You just have to run the form and everything just works.

If that's not the case, yes - you can set the relationship manually.

Report message to a moderator

Previous Topic:	Forms 12c problem
Next Topic:	Disable F10 in oracle forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 06:53:54 CDT 2025