Custom forms issue in oracle forms 6i

Posted on 2008-11-19
Last Modified: 2013-12-11

I am developing a custom form using Oracle forms 6i. One of the requirements is, when the form is opened,  the datablock should be queried and the records should be displayed in the form. ie.. there should be no need to manually press f11 and ctrl + f11. I have specified the "Where" condidtion in the datablock and the query happens when i press ctrl + f11. I am not able to figure out how the records can be displayed automatically when the form loads.. I am using a single table in the datablock.

Kindly help.. i am quite new to Oracle forms.
Question by:sreejithm
    LVL 20

    Accepted Solution

    add the statement


    in the when_new_form_instance-trigger


    Author Comment

    thanks. When I tried this in another form where there are many tabs and in each tab we have a different data block, when the form loads, the query is executed only in the first tab. Kindly advise the work around for this. So that the query is executed in all the datablocks.
    LVL 6

    Assisted Solution

    Use go_block or go_item for each block that you have:


    Open in new window


    Author Closing Comment

    Thank you so much flow01 & Ritesh. This worked perfectly.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    737 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

    16 Experts available now in Live!

    Get 1:1 Help Now