11 Replies Latest reply: Jan 22, 2013 1:13 AM by HamidHelal RSS

    Clearing block A and navigating to a new block B

    664787
      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?