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: 610
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 763 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: 21782
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

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

Tue, 04 July 2023 05:07

azamkhan
Messages: 557
Registered: August 2005

Senior Member

You can also use current record attribute on master block for high lighting current navigated record.

Report message to a moderator

Previous Topic:	Reports in pdf format generated in server but don't open in local machine
Next Topic:	Language

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 02:28:24 CDT 2023