OraFAQ Forum: Forms » FIND

Home » Developer & Programmer » Forms » FIND_FORM error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FIND_FORM error [message #333636]

Sun, 13 July 2008 23:40

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

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

Report message to a moderator

Re: Find Form [message #333661 is a reply to message #333636]

Mon, 14 July 2008 01:36

Littlefoot
Messages: 21823
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;

Report message to a moderator