OraFAQ Forum: Forms » call_form() can't work.thanks!

Home » Developer & Programmer » Forms » call_form() can't work.thanks!

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

call_form() can't work.thanks! [message #242726]

Mon, 04 June 2007 21:11

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!

Report message to a moderator

Re: call_form() can't work.thanks! [message #242730 is a reply to message #242726]

Mon, 04 June 2007 22:35

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.

Report message to a moderator

Re: call_form() can't work.thanks! [message #242732 is a reply to message #242726]

Mon, 04 June 2007 22:59

mell.gu
Messages: 6
Registered: June 2007
Location: China

Junior Member

Thank you very much yahya_mukhtar.

Report message to a moderator

Re: call_form() can't work.thanks! [message #242749 is a reply to message #242730]

Mon, 04 June 2007 23:57

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

Report message to a moderator

Re: call_form() can't work.thanks! [message #242750 is a reply to message #242749]

Mon, 04 June 2007 23:59

yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan

Junior Member

hi
i cant understand ur question . plz explain again.....
thanx.

Report message to a moderator

Re: call_form() can't work.thanks! [message #242766 is a reply to message #242750]

Tue, 05 June 2007 01:05

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

Report message to a moderator

Re: call_form() can't work.thanks! [message #242780 is a reply to message #242750]

Tue, 05 June 2007 01:50

mell.gu
Messages: 6
Registered: June 2007
Location: China

Junior Member

YES!
But where i can find the FORMS90_PATH to store the paths?

Report message to a moderator

Re: call_form() can't work.thanks! [message #242813 is a reply to message #242726]

Tue, 05 June 2007 03:52

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.

Report message to a moderator

Re: call_form() can't work.thanks! [message #242822 is a reply to message #242813]

Tue, 05 June 2007 04:11

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 1010 times)

Report message to a moderator

Re: call_form() can't work.thanks! [message #242838 is a reply to message #242726]

Tue, 05 June 2007 04:51

mell.gu
Messages: 6
Registered: June 2007
Location: China

Junior Member

Thank you very much!
Everybody is very frendly!

Report message to a moderator

Re: call_form() can't work.thanks! [message #242841 is a reply to message #242838]

Tue, 05 June 2007 04:54

yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan

Junior Member

thanks for ur reply.....

Report message to a moderator

Re: call_form() can't work.thanks! [message #242845 is a reply to message #242726]

Tue, 05 June 2007 04:57

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

Report message to a moderator

Re: call_form() can't work.thanks! [message #242847 is a reply to message #242845]

Tue, 05 June 2007 05:04

yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan

Junior Member

hi
first i try this and then told u ur question....

Report message to a moderator

Previous Topic:	ORA-12203: TNS:unable to connect to destination....
Next Topic:	FRM-18126 could not invoke browser

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 13:45:15 CST 2024