This discussion is archived
11 Replies Latest reply: Jan 21, 2013 11:13 PM by HamidHelal RSS

Clearing block A and navigating to a new block B

664787 Pro
Currently Being Moderated
Hi Guys,

I've restarted work on oracle forms after almost 3 years and seem to have forgotten the basic things.
I've a very simple question and hope someone can give me a quick answer.

So, i've a data block A based on a view V1 and a data block B based on view V2.
By default, when i open the form, data block A is shown and populated.
There is a button [show all], which should display data block B.
The code on show all button is
  clear_block;
  go_block('B');
  do_key('execute_query');
 
However, it doesn't show the records of V2 on data block B.
Can you please help me solve this issue?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points