OraFAQ Forum: Forms » insert value in detail block after selecting the master block

Home » Developer & Programmer » Forms » insert value in detail block after selecting the master block (form 6i)

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

insert value in detail block after selecting the master block [message #687311]

Sun, 19 February 2023 01:45

shahzad-ul-hasan
Messages: 607
Registered: August 2002

Senior Member

i have master detail form. which contain master block and detail block.when i insert record in detail block the master record should be highlighted.
please check the attached file.
i am using this code in when new record instance.

if :bkk_dett.bksno = :bkk_det.bksno then
	  go_block('BKK_DET');
	  set_item_instance_property('bksno',current_record,'VA');
	  set_item_instance_property('bkclass',current_record,'VA');
end if;

Attachment: qqq.png
(Size: 70.56KB, Downloaded 116 times)

Report message to a moderator

Re: insert value in detail block after selecting the master block [message #687313 is a reply to message #687311]

Mon, 20 February 2023 03:27

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

Senior Member
Account Moderator

Two objections.

If you first GO_BLOCK (to detail block) and then want to modify master block's properties then CURRENT_RECORD doesn't point to master, but detail record so I'd say that SET_ITEM_INSTANCE_PROPERTY should go first, and GO_BLOCK next.

Status line shows that there was and error in WHEN-NEW-BLOCK-INSTANCE trigger. That might prevent some other code to be executed so ... fix that error.

Report message to a moderator

Previous Topic:	NVL VS Group by
Next Topic:	Debugging Constraint error on Forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 02 02:28:27 CDT 2023