Call form , can't find the form [message #226706] |
Mon, 26 March 2007 04:46 |
ShaShalini
Messages: 59 Registered: January 2007
|
Member |
|
|
Hi friends
I don't want my user to access a particular form directly from the URL. The user should be able to access only the login form from the URL.
I have put all my forms in a directory and I have included the path in the default.env file in the formspath.
e.g /d01/data/forms ..
this form contains only the login form.
now in the /d01/data/forms/fmx
this directory contains all other forms. When I do a call form from , it is not able to find the path and the forms
Any help ...
Thanks
|
|
|
|
Re: Call form , can't find the form [message #227067 is a reply to message #226940] |
Tue, 27 March 2007 04:27 |
|
bhupinderbs
Messages: 67 Registered: July 2006 Location: Bangalore
|
Member |
|
|
Hi
Try this code. What is does, it selects the path of your first form or login form and runs all other forms from that path.
FUNCTION f_get_file_path RETURN Varchar2 IS
v_curr_form Varchar2(40) := NAME_IN('SYSTEM.CURRENT_FORM');
lc_rep_path VARCHAR2(200);
--formmodule_id FormModule := FIND_FORM(UPPER(GET_APPLICATION_PROPERTY(CURRENT_FORM_NAME)));
formmodule_id FormModule := FIND_FORM(UPPER(v_curr_form));
BEGIN
lc_rep_path := LOWER(GET_FORM_PROPERTY(formmodule_id,file_name));
lc_rep_path := SUBSTR(lc_rep_path,1, INSTR(lc_rep_path,'\',-1));
RETURN lc_rep_path;
END;
Bhupinder Singh
|
|
|