We help IT Professionals succeed at work.
Get Started

how to display this new record right away after inserting a new record?

wasabi3689 asked
Last Modified: 2013-12-19
I am working on a oracle form development form version - 11.0.30

I have a master form (block) and a detail form(block) linked by license_id. In the detail form, there is a button. When clicking the button, that will call a procedure to insert a new record to the table

Here is what I process the form.
1. open the master form -LICENSE then go Query->Enter, then input a license_number to display master data.
2. In the master form, there is a button. When clicking this button, it will open a new form and display detail info.
3. There is a button on the detail form to create a new record. Once  the detail form opened, user can press the button to create a new record.

However, I don't see instant results shown on the detail when clicking on the button on detail form. To see the new results, I have to open the detail form and do 1, 2 steps again.

Is there any way to see the result instantly after I press the button on the detail form?
No need to leave the form and re-query again
Watch Question
Top Expert 2004
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE