Home » Developer & Programmer » Forms » Dynamic Coordination!! for control blocks
Dynamic Coordination!! for control blocks [message #198626] Wed, 18 October 2006 01:01 Go to next message
chengam
Messages: 4
Registered: May 2006
Junior Member
Hi all,

I have two control blocks, and an LOV is written on one of the ITEM of a Control Block.

The requirement is as soon as the user enters the Value from the LOV.

The records should be populated in the other control block without any delay!!

NOTE: There is no MASTER-DETAIL relations between the blocks!!

Please help!!
Re: Dynamic Coordination!! for control blocks [message #198653 is a reply to message #198626] Wed, 18 October 2006 02:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please search this forum , reference manual, or google for 'default_where' and 'key-listval' and 'show_lov'.

In the 'key-listval' trigger do the 'show_lov', verify that 'okay' has been pressed, use the 'set_block_property' command's 'default_where' property for the OTHER block, then do a 'go_block' and an 'execute_query'.

Try that and get back to us.

David
Re: Dynamic Coordination!! for control blocks [message #198729 is a reply to message #198653] Wed, 18 October 2006 06:32 Go to previous messageGo to next message
chengam
Messages: 4
Registered: May 2006
Junior Member
Hi David,

Thanks for your concern, I looked at Google and this Forum also but I couldn't get what I require!!

Briefly I will explain the requirement,

Control Blocks Names are:

BLOCK:1 Customer ( Control Block)
ITEM:1 SHIP_TO ( TEXT ITEM ) with LOV
ITEM:2 CUSTOMER_NAME (DISPLAY ITEM)
ITEM:3 LIST_SHIP_TO (PUSH BUTTON)

BLOCK:2 HOK (Control Block) (Multi-Record Block)

ITEM:1 Orderno
ITEM:2 Purchase Order
ITEM:3 Last_recieving_date
ITEM:4 Invoice_number


(All are display Items)

Requirement:

When the USER Enter the SHIP_TO ( TEXT ITEM ) or Chooses the Value from the LOV.

Expected Result:

The ITEMS in the HOK (Multi-Record Block) should be populated on choosing the Value from LOV.

Can be done using Cursors but I don't know exactly at what instance ( that is at what trigger ) to call the Cursors.

Tried using the 'key-listval','show_lov','default_where' but nothing works as expected!!

Please help!!

Re: Dynamic Coordination!! for control blocks [message #198859 is a reply to message #198729] Wed, 18 October 2006 20:24 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at this lot:
Populate block using cursor
http://www.orafaq.com/forum/m/605/67467/?srch=populate+block+cursor+create_record#msg_605
and my feelings about it.
http://www.orafaq.com/forum/m/134237/67467/?srch=populate+block+cursor+create_record#msg_134237

Loading data into a block MANUALLY
http://www.orafaq.com/forum/m/111031/67693/#msg_111031
MANUAL previous and next master key record retrieval
http://www.orafaq.com/forum/m/111031/67693/#msg_111031
Sample MANUAL get employees form
http://www.orafaq.com/forum/t/52330/67467/

David

[Updated on: Wed, 18 October 2006 20:25]

Report message to a moderator

Previous Topic: how to call form form server
Next Topic: Problem in setting Visual Attributes
Goto Forum:
  


Current Time: Fri Dec 09 19:46:19 CST 2016

Total time taken to generate the page: 0.07157 seconds