Home » Developer & Programmer » Forms » call_form() can't work.thanks!
call_form() can't work.thanks! [message #242726] Mon, 04 June 2007 21:11 Go to next message
mell.gu
Messages: 6
Registered: June 2007
Location: China
Junior Member

i use a push button and write down
call_form('signup'); in when-button-pressed trigger ,when run it but nothing is displayed,the error info is can't read form signup(the form signup running is ok)

friends,how can i do to call form signup?

thanks!
Re: call_form() can't work.thanks! [message #242730 is a reply to message #242726] Mon, 04 June 2007 22:35 Go to previous messageGo to next message
yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan
Junior Member

the answer id that when ever u use the open_form or call_form . u must define the full path of that form where the form is reside other wise its not working that is in ur form error.
Re: call_form() can't work.thanks! [message #242732 is a reply to message #242726] Mon, 04 June 2007 22:59 Go to previous messageGo to next message
mell.gu
Messages: 6
Registered: June 2007
Location: China
Junior Member

Thank you very much yahya_mukhtar.
Re: call_form() can't work.thanks! [message #242749 is a reply to message #242730] Mon, 04 June 2007 23:57 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
define the full path ...

Couldn't one put this full path into the FORMS90_PATH instead and forget about hardcoding it into the form?
Re: call_form() can't work.thanks! [message #242750 is a reply to message #242749] Mon, 04 June 2007 23:59 Go to previous messageGo to next message
yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan
Junior Member
hi
i cant understand ur question . plz explain again.....
thanx.
Re: call_form() can't work.thanks! [message #242766 is a reply to message #242750] Tue, 05 June 2007 01:05 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's FORMS90_PATH which is used to store a path to directories you use when working with forms. You can add any directory into it, including the one which holds the 'signup' form from the original post.

I thought that this might be a better idea than hardcoding the whole path into the CALL_FORM.
Re: call_form() can't work.thanks! [message #242780 is a reply to message #242750] Tue, 05 June 2007 01:50 Go to previous messageGo to next message
mell.gu
Messages: 6
Registered: June 2007
Location: China
Junior Member

YES!
But where i can find the FORMS90_PATH to store the paths?
Re: call_form() can't work.thanks! [message #242813 is a reply to message #242726] Tue, 05 June 2007 03:52 Go to previous messageGo to next message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
in the registry if you are using windows O/S.

go to start > run, there type REGEDIT and say ok
Go to HKEY_local_machine > Software>Oracle. In the main itself you'll file FORMS90_PATH. Just add your application path there.
Re: call_form() can't work.thanks! [message #242822 is a reply to message #242813] Tue, 05 June 2007 04:11 Go to previous messageGo to next message
yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan
Junior Member
hi

i thing i ask about the forms90_paths is that if u change the position of the fmx files.
means first time he files r in the d:\ drive but now these r in the e :\ drive then at this point u change the path again in the registry.
i think that this is not good i send u file this is vry helpful to u . bez u can paste ur fmx file into any folder they automatically deduct the path.
u use this as a function in every forms.
  • Attachment: test.txt
    (Size: 0.21KB, Downloaded 162 times)
Re: call_form() can't work.thanks! [message #242838 is a reply to message #242726] Tue, 05 June 2007 04:51 Go to previous messageGo to next message
mell.gu
Messages: 6
Registered: June 2007
Location: China
Junior Member

Thank you very much!
Everybody is very frendly!
Re: call_form() can't work.thanks! [message #242841 is a reply to message #242838] Tue, 05 June 2007 04:54 Go to previous messageGo to next message
yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan
Junior Member
thanks for ur reply.....
Re: call_form() can't work.thanks! [message #242845 is a reply to message #242726] Tue, 05 June 2007 04:57 Go to previous messageGo to next message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
there are lot many different ways to handle this, if you donot want to "upset" the registry.

easiest way is set the path in a global variable when your menu loads. after than you concatenate the name of the form/report with the global variable while specifying file name.

another option is keep a table in the system user or in your db's base user and give all users only select rights to it. (you can do this by granting select access to "CONNECT" and then granting this role to all users.) Put a column in this table where you will store the path. write a function on this table to pick up the path. Contatenate that path and the name of the form/report while specifying file name.
Using this method, you can also speficy multiple paths for different modules, e.g. Sales Module, Finance Module, HR/Payroll etc.
-------------------
Yahya,
what happens when your main module and the subsequent sub modules are in a different folder?

Rgrds,
Hema
Re: call_form() can't work.thanks! [message #242847 is a reply to message #242845] Tue, 05 June 2007 05:04 Go to previous message
yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan
Junior Member
hi
first i try this and then told u ur question....
Previous Topic: ORA-12203: TNS:unable to connect to destination....
Next Topic: FRM-18126 could not invoke browser
Goto Forum:
  


Current Time: Sat Dec 03 08:14:11 CST 2016

Total time taken to generate the page: 0.12677 seconds