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

Posted on 2009-02-12
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
Question by:wasabi3689
    LVL 27

    Accepted Solution

    you can simple requrey your detail-block (without leaving the form)
    as sceleton in your button-pressed-trigger


    usual i have no experience with maybe new features of version 11.0.30,
    therfore, i could also be on a wrong track

    meikl ;-)

    LVL 22

    Expert Comment

    by:Helena Marková
    I think that answer is good :).
    What is your Form builder version (when clicking on Help->AboutForm Builder...)? Mine is Forms [32 Bit] Version (Production) - it is Forms10g.
    It seems to me that 11.0.30 is the version of customized Oracle Application.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now