OraFAQ Forum: Forms » Check the fmx file whether exists or not?

Home » Developer & Programmer » Forms » Check the fmx file whether exists or not? (Forms 6i)

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

Check the fmx file whether exists or not? [message #309324]

Thu, 27 March 2008 02:11

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

Hi , Can i check the fmx file whether exists or not before call them through menu? if so please tell me how to do it?

Upd: Remove 'code' tags.

[Updated on: Thu, 27 March 2008 18:02] by Moderator

Report message to a moderator

Re: Check the fmx file whether exists or not? [message #309353 is a reply to message #309324]

Thu, 27 March 2008 03:22

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know; but you may trap the exception once it is raised. Use the ON-ERROR trigger and FRM-40108 error code.

Report message to a moderator

Re: Check the fmx file whether exists or not? [message #309364 is a reply to message #309324]

Thu, 27 March 2008 03:58

azamkhan
Messages: 557
Registered: August 2005

Senior Member

When ever you issue call form or new form then if the file is not there ON-ERROR message generates an error and in this way you can trap this event.

Regards,
Azam Khan

Report message to a moderator

Re: Check the fmx file whether exists or not? [message #309366 is a reply to message #309364]

Thu, 27 March 2008 04:11

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

Cannot trap this event in On-Error trigger. Because i am calling this fmx through Menu . There is no ON-Error Trigger in menu module.
Is any other method to check whether exists or not?

[Updated on: Thu, 27 March 2008 18:03] by Moderator

Report message to a moderator

Re: Check the fmx file whether exists or not? [message #309386 is a reply to message #309366]

Thu, 27 March 2008 05:05

azamkhan
Messages: 557
Registered: August 2005

Senior Member

no trap it on Forms ON-Error.

Regards,
Azam Khan

Report message to a moderator

Re: Check the fmx file whether exists or not? [message #309554 is a reply to message #309366]

Thu, 27 March 2008 18:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Can you issue a 'host' command from a menu? If yes, then run a batch file to test if the 'fmx' exists. But why worry? If it doesn't exist the system will tell you.

David

Report message to a moderator

Re: Check the fmx file whether exists or not? [message #309668 is a reply to message #309324]

Fri, 28 March 2008 06:47

Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec

Senior Member

Maybe you can use something like this to trap error in your menu

  open_form(p_module, ACTIVATE, SESSION, NO_SHARE_LIBRARY_DATA, pl_id);
  IF NOT form_success THEN
    message('Unable to call module');
    raise form_trigger_failure;
  END IF;

Report message to a moderator

Re: Check the fmx file whether exists or not? [message #310322 is a reply to message #309668]

Mon, 31 March 2008 23:33

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

thank you very much kaeluan. Given code solved my problem.

Report message to a moderator

Re: Check the fmx file whether exists or not? [message #310326 is a reply to message #309554]

Mon, 31 March 2008 23:40

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

If the file does not  exists , system will give the error message to User. 
But here my requirement is  if the given fmx is not exists then  i need to call another fmx . 
Mr.Kaeluan gave me the solution to met the requirement.

Report message to a moderator

Previous Topic:	Disable/Enable current item in tabular block
Next Topic:	Prevent concurrent users from accessing records in form by locking

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 02 05:57:47 CDT 2026