This content has been marked as final.
Show 8 replies
-
1. Re: How to populate items from two data blocks when clicking execute query?
twinklin_girl Jul 6, 2009 10:21 AM (in response to twinklin_girl)bump -
2. Re: How to populate items from two data blocks when clicking execute query?
429406 Jul 6, 2009 10:28 AM (in response to twinklin_girl)Hello
Try creating a relationship between both the blocks and see if you can.
Regards
Sasidhar
Edited by: Sasidhar.P on Jul 6, 2009 3:57 PM -
3. Re: How to populate items from two data blocks when clicking execute query?
Fabrizio Delli Priscoli Jul 6, 2009 10:28 AM (in response to twinklin_girl)Both blocks are base table?
If so, in the post-query trigger of your first block put this code:
Hope it helps you,go_block('your_second_block'); execute_query;
Fabrizio
If this answer is helpful or correct, please mark it. Thanks. -
4. Re: How to populate items from two data blocks when clicking execute query?
RKP Jul 6, 2009 12:15 PM (in response to twinklin_girl)Create a block level execute query trigger.1 person found this helpful
Do the code like below.
Execute_query;
next_block;
execute_query;
Thanks,
SUN -
5. Re: How to populate items from two data blocks when clicking execute query?
twinklin_girl Jul 6, 2009 12:17 PM (in response to Fabrizio Delli Priscoli)Hi Fabrizio , this is what I did but I get the following error :
Error : 40737 - Illegal restricted procedure GO_BLOCK in POST-QUERY trigger. -
6. Re: How to populate items from two data blocks when clicking execute query?
Fabrizio Delli Priscoli Jul 6, 2009 12:20 PM (in response to twinklin_girl)So, try to move the code into a block level execute trigger.
Fabrizio -
7. Re: How to populate items from two data blocks when clicking execute query?
twinklin_girl Jul 6, 2009 12:23 PM (in response to RKP)Thanks it works now :) -
8. Re: How to populate items from two data blocks when clicking execute query?
494921 Feb 8, 2013 9:09 AM (in response to 429406)Thanks