Home » Developer & Programmer » Forms » problem with master detail
problem with master detail [message #682024] Sun, 27 September 2020 15:23 Go to next message
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
Re: problem with master detail [message #682025 is a reply to message #682024] Sun, 27 September 2020 15:45 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: problem with master detail [message #682027 is a reply to message #682025] Sun, 27 September 2020 15:51 Go to previous messageGo to next message
compuscience
Messages: 97
Registered: September 2012
Member
then you say that i must made primary key right or link between columns only
Re: problem with master detail [message #682031 is a reply to message #682027] Mon, 28 September 2020 02:34 Go to previous message
Littlefoot
Messages: 21806
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.
Previous Topic: Forms 12c problem
Next Topic: Disable F10 in oracle forms
Goto Forum:
  


Current Time: Thu Mar 28 15:51:04 CDT 2024