Home » Developer & Programmer » Forms » FIND_FORM error
FIND_FORM error [message #333636] Sun, 13 July 2008 23:40 Go to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

Hi all,
I am using Find_Form keyword for closing the Form automatically....,means i am using tree view for menu.
so the users will open n number of forms so that they want to close entire application by pressing one time.

so i m insert into a dummy table whenever the users opening a form. this table contains formname and sessionid. its working fine. it is closing all other forms and application also.

But user may close the form manually, but my table having that formname. so when i am executing
close_Form(form_name);
it gives
FRM-40739:Argument 1 to builtin CLOSE_FORM cannot be null

i cannot write the delete statement in each & every form.
If form is not opened then automatically delete st should get execute after that close_form.

is there any execption? how to do this? pls tell me..

Regards,
Kalyan

[MERGED by LF]

[Updated on: Mon, 14 July 2008 01:41] by Moderator

Report message to a moderator

Find_Form Error [message #333637 is a reply to message #333636] Sun, 13 July 2008 23:50 Go to previous messageGo to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

hi all,
I have one doubt in Find_Form(..).
Actually Find_Form will find the Formmodule and return.
Suppose there is no form like that...then how to find out there is no form like that..

Declare
P_Form_Module FORMMODULE;
P_Form Varchar2(100):='INVOICE';
Begin
P_Form_Module:=Find_Form(p_Form);
Close_Form(P_Form_Module);
End;

Now If that Form Exist means No Problem. But does not exist means FRM-40738 Error Is Coming. so i want give a message
"there is no form exist".

How to do this? Any one please tell me.

Regards,
Kalyan
Re: Find Form [message #333661 is a reply to message #333636] Mon, 14 July 2008 01:36 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know whether something like this might be useful for you, but you might take a look:
declare
  frm_id formmodule;
begin
  -- simulate your situation, where user closes the form manually
  frm_id := null;
	
  -- check whether frm_id is null or not; if it is, make it 
  -- equal to the current form (just to avoid it being null)
  if id_null(frm_id) then
     frm_id := find_form(:system.current_form);
  end if;

  close_form(frm_id);
end;
Re: Find Form [message #333665 is a reply to message #333661] Mon, 14 July 2008 01:48 Go to previous messageGo to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

Thanks littlefoot,
i will try this...
Re: Find Form [message #338768 is a reply to message #333665] Tue, 05 August 2008 21:29 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Also have a look at http://www.orafaq.com/forum/m/318436/67467/?srch=when-navigate+global#msg_318436

David
Previous Topic: Need help
Next Topic: How handle Oracle Form own generated Error
Goto Forum:
  


Current Time: Thu Dec 08 02:09:49 CST 2016

Total time taken to generate the page: 0.09163 seconds