Home » Developer & Programmer » Forms » How to check Opened forms in a session before switching into different responsibility (Oracle forms, 10G, Windows 7)
How to check Opened forms in a session before switching into different responsibility [message #612276] Tue, 15 April 2014 08:50 Go to next message
pramod.sramesh
Messages: 23
Registered: November 2011
Location: Bangalore
Junior Member
Hi Experts,

I am working on Oracle forms 10g (OS: Windows7) from last 2 years. I have got a requirement to notify the user if there are any opened forms before switching in to different responsibility or i want to close all opened forms before switching to different responsibility.

Thanks,
Pramod
Re: How to check Opened forms in a session before switching into different responsibility [message #612334 is a reply to message #612276] Wed, 16 April 2014 02:34 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
What does different responsibility mean?
Re: How to check Opened forms in a session before switching into different responsibility [message #612335 is a reply to message #612334] Wed, 16 April 2014 03:09 Go to previous messageGo to next message
pramod.sramesh
Messages: 23
Registered: November 2011
Location: Bangalore
Junior Member
Hi Cookiemonster..!!

Thanks for your time. I am working on oracle forms. My question is i want to close all the opened forms before opening a particular form from the menu. I want to know whether any form is opened or not. How to achieve this. Please help on this.

Pramod SR

[Updated on: Wed, 16 April 2014 03:11]

Report message to a moderator

Re: How to check Opened forms in a session before switching into different responsibility [message #612336 is a reply to message #612335] Wed, 16 April 2014 03:18 Go to previous message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
("Responsibility" sound Oracle Apps.-ish to me).

Andreas Weiden suggests
IF ID_NULL(FIND_FORM('YOUR_FORM')) THEN
  -- not found
ELSE
  -- found
END IF;
Try it.

[Updated on: Wed, 16 April 2014 03:18]

Report message to a moderator

Previous Topic: Grouping Rows in Excel using client_ole2
Next Topic: 11g Forms Not Running
Goto Forum:
  


Current Time: Fri Apr 26 09:53:08 CDT 2024