Have one block update another [message #653661] |
Wed, 13 July 2016 11:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bf20a5d3159f1c3de0ff18acc160d357?s=64&d=mm&r=g) |
Melancolie
Messages: 2 Registered: July 2016
|
Junior Member |
|
|
I am new to forms, and i've tried googling/searching for this issue without luck, so hope you'll be patient if my question is stupid.
I have block ID_NUMBERS that gets populated through when-new-form-instance. This block holds a list of identification numbers that has issues and need to be handled manually.
These id's can come from a variety of sources, so i have 3 other blocks; INFO, RELATIONS and RELATIONS_MANUAL. Not all id's will be populating all 3 blocks.
I've made a stored procedure FETCH_INFO that populates the blocks based on the type of id. This works perfectly.
I would very much like the user to be able to browse through the ID's in the ID_NUMBERS block and have the FETCH_INFO procedure executed everytime a new ID is selected.
I simply cant get this to work since i have a number of GO_BLOCK inside FETCH_INFO.
Is this at all possible, or do i need a button SHOW_INFORMATION that users will have to manually click?
|
|
|
|
|
Re: Have one block update another [message #653706 is a reply to message #653693] |
Fri, 15 July 2016 03:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
WNRI will do the job, you just have to careful to avoid an infinite navigation loop.
If it runs a procedure that goes to other blocks then back to the block the trigger is on (cause you want the cursor end back where it started) that'll cause WNRI to fire again. You can avoid the second fire from doing anything by setting and checking a global variable.
|
|
|