Home » Developer & Programmer » Forms » Check the fmx file whether exists or not? (Forms 6i)
Check the fmx file whether exists or not? [message #309324] Thu, 27 March 2008 02:11 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Check the fmx file whether exists or not? [message #309364 is a reply to message #309324] Thu, 27 March 2008 03:58 Go to previous messageGo to next message
azamkhan
Messages: 548
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
Re: Check the fmx file whether exists or not? [message #309366 is a reply to message #309364] Thu, 27 March 2008 04:11 Go to previous messageGo to next message
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 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
no trap it on Forms ON-Error.

Regards,
Azam Khan
Re: Check the fmx file whether exists or not? [message #309554 is a reply to message #309366] Thu, 27 March 2008 18:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Check the fmx file whether exists or not? [message #309668 is a reply to message #309324] Fri, 28 March 2008 06:47 Go to previous messageGo to next message
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;
Re: Check the fmx file whether exists or not? [message #310322 is a reply to message #309668] Mon, 31 March 2008 23:33 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
thank you very much kaeluan. Given code solved my problem.

Re: Check the fmx file whether exists or not? [message #310326 is a reply to message #309554] Mon, 31 March 2008 23:40 Go to previous message
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.
Previous Topic: Disable/Enable current item in tabular block
Next Topic: Prevent concurrent users from accessing records in form by locking
Goto Forum:
  


Current Time: Sun Dec 11 00:12:35 CST 2016

Total time taken to generate the page: 0.05396 seconds