how to hide/close form itself in Oracle 8i application?

Posted on 2008-11-05
Last Modified: 2013-12-19
I have a search form called "Find Downloads". There is "Find" button. When I click find, if exist, it will open another form, if not, the search form will stayed, not closed

Now I want  the search form close itself if it finds something and open another form. If not find, just stay in the same search form.

So far the Find button trigger
 is  like that

:parameter.G_query_find := 'TRUE';
:parameter.G_query_find := 'FALSE';

How to modify it to have my purpose?
Question by:wasabi3689
    LVL 22

    Expert Comment

    Is it Oracle Forms ?

    Author Comment

    yes, oracle 8i form
    LVL 22

    Expert Comment

    I am not sure it can be done, maybe someone else can help you.
    LVL 20

    Accepted Solution

    I don't know what happens in  'app_find.find'  but if  you open 'another form'  bij means of OPEN_FORM('another form') , you could try 'NEW_FORM('another form').

    Exits the current form and enters the indicated form.

    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

    Suggested Solutions

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    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.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    734 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

    22 Experts available now in Live!

    Get 1:1 Help Now