how to close a form in Oracle 8i form application?

I am designing an oracle 8i application using oracle form builder

I design a form "Find Download". When I close this form by clicking the right top close (X), it comes up the empty detail download form. Then I close the detail form to also close the "Find Download" form

But what I want is close the Find Download" Form, that is all, no need to open detail download form.

That is because I put the following in the Find Download form

Next Navigation Block         XX_DOWNLOADS_V
Previous Navigation Block  XX_DOWNLOADS_V


But If I change Previous Navigation Block to null, when I close the form, it open "Export" form.
if  I change Previous Navigation Block to Find_Download block, I cannot close the Find_download form

In my Find Download form, I have a button "Find" with the following code

:parameter.G_query_find := 'TRUE';
app_find.find('XX_DOWNLOADS_V');
:parameter.G_query_find := 'FALSE';


How to fix this problem?

wasabi3689Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dr_BillyCommented:
Can you give more details about how your navigation works ? its a bit ambiguous the way you described it
0
wasabi3689Author Commented:
I attached 3 photos for you

1. Find_download open
2 click on Close (X) on the coner of the form
3. open download form

I want to close find_download form, just close, no need to pop up download form
find-download.JPG
download.JPG
struture.JPG
0
wasabi3689Author Commented:
any ideas?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Dr_BillyCommented:
When you close the current window for Find_Downloads then the forms are searching a navigable block that can set the focus to , that's why you need to specify one programmatic so you can set the focus your self instead of letting forms deciding on that.
 
One more thing that I need to know , how do you call that window ? I mean is it the main screen when the form starts up ? if not what is the main screen that appears before you call this window , since you need to get to that window again after that screen loses the focus .

Try that now and hope that will solve your problem

Create a trigger on the form level

WHEN-WINDOW-CLOSED

and place the following code in it
IF :System.Event_Window = 'Window that holds your Find_Downloads' THEN 
  Set_Window_Property('Window that holds your Find_Downloads', VISIBLE, PROPERTY_OFF); 
else
  Go_Block('Name of any other block you want the focus to be set at');
END IF;

Open in new window

0
Dr_BillyCommented:
and by the way , are these separate forms or both screens are in the same form but in different blocks ?
0
wasabi3689Author Commented:
It still pop up another form when I close it.

it's in the same form but in different blocks

I have

WHEN-WINDOW-CLOSED

execute_trigger('CLOSE_WINDOW');

CLOSE_WINDOW

APP_CUSTOM.CLOSE_WINDOW(:SYSTEM.EVENT_WINDOW);


--execute_trigger('CLOSE_WINDOW');
 
IF :System.Event_Window = 'Find_Downloads' THEN 
  Set_Window_Property('Find_Downloads', VISIBLE, PROPERTY_OFF); 
else
  Go_Block('XX_Downloads_V');
END IF;

Open in new window

0
Dr_BillyCommented:
are you sure that your trigger is firing ? put a message in the trigger to ensure you are firing the trigger when closing the window . and let me know what happens !
0
Dr_BillyCommented:
The user never got back to us on the status of fixes we suggested ..... !
0
Dr_BillyCommented:
The user never got back to us on the status of fixes we suggested ..... !
0
wasabi3689Author Commented:
Hi Dr Billy. I' ve known you are very talented and you saved me in several tickets before. I very appreciated.
This ticket I found a very simple solution -  just move Find_Download block down below control block. Then the problem solved.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dr_BillyCommented:
Am glade that you have found a solution , but as the moderator mentioned above always respond to your tickets .

Best of luck.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.