OraFAQ Forum: Forms » How to change master block's data when detail block's data changed?

Home » Developer & Programmer » Forms » How to change master block's data when detail block's data changed? (Forms 10.1.2 Win2003)

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

How to change master block's data when detail block's data changed? [message #357472]

Wed, 05 November 2008 08:49

since
Messages: 18
Registered: May 2008

Junior Member

I have a master block like:

ID, Name, Number
1,  aaa,  44
2,  bbb,  33

detail block like

ID, Operation, Number
1,  ADD,       5
1,  ADD,       22

Related with ID.

The question is, When the detail block record changed (insert/modify/delete), How to update the master block's 'Number' column?

Thanx!

[Updated on: Wed, 05 November 2008 08:50]

Report message to a moderator

Re: How to change master block's data when detail block's data changed? [message #357505 is a reply to message #357472]

Wed, 05 November 2008 12:23

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

Senior Member
Account Moderator

Using one of forms' triggers? WHEN-VALIDATE-RECORD, for example?

Report message to a moderator

Re: How to change master block's data when detail block's data changed? [message #357563 is a reply to message #357505]

Wed, 05 November 2008 19:08

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

Senior Member
Account Moderator

LF,

We can't do 'restricted' commands in WHEN-VALIDATE-RECORD.

David

Report message to a moderator

Re: How to change master block's data when detail block's data changed? [message #357564 is a reply to message #357472]

Wed, 05 November 2008 19:09

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

Senior Member
Account Moderator

What is the relationship between 'number' in the detail block and 'number' in the master block because 5 plus 22 is not 44.

David

Report message to a moderator

Re: How to change master block's data when detail block's data changed? [message #357594 is a reply to message #357564]

Thu, 06 November 2008 00:16

since
Messages: 18
Registered: May 2008

Junior Member

djmartin wrote on Wed, 05 November 2008 19:09

What is the relationship between 'number' in the detail block and 'number' in the master block because 5 plus 22 is not 44.

David

The 'number' column do not have any relationship.

For example, I insert an record to the detail block like:

1,ADD,6

the Number in master block of current record should changed from 44 to 50 (44+6=50)

thank you for your reply!

Report message to a moderator

Re: How to change master block's data when detail block's data changed? [message #357595 is a reply to message #357563]

Thu, 06 November 2008 00:17

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

Senior Member
Account Moderator

djmartin wrote on Thu, 06 November 2008 02:08

LF,

We can't do 'restricted' commands in WHEN-VALIDATE-RECORD.

David

I know; my idea was something like

-- calculations here
:upper_block.number_item := result_of_the_calculation;

but, after your post, perhaps it wasn't that good idea. It appears that it should be more like

-- calculations here
UPDATE upper_block_table SET
  number_column = result_of_the_calculation
  WHERE id = some_id;

GO_BLOCK('uppaer_block');
EXECUTE_QUERY;

which certainly wouldn't be possible in a trigger of my choice.

Report message to a moderator

Re: How to change master block's data when detail block's data changed? [message #357605 is a reply to message #357594]

Thu, 06 November 2008 00:48

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

Senior Member
Account Moderator

Seeing that this is a straight master-detail relationship, and the master record you want to change is this detail record's master then just do a ':blk_mst.number := :blk_mst.number + :blk_dtl.number' in the When-Validate-Item' trigger. You don't have to be IN an item to change it.

David

Report message to a moderator