Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Clearing block A and navigating to a new block B

664787Jan 21 2013 — edited Jan 22 2013

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2013

Added on Jan 21 2013

#forms, #moved-from-devops

11 comments

261 views