Home » Developer & Programmer » Forms » Call form , can't find the form
Call form , can't find the form [message #226706] Mon, 26 March 2007 04:46 Go to next message
Messages: 59
Registered: January 2007
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 ...

Re: Call form , can't find the form [message #226940 is a reply to message #226706] Tue, 27 March 2007 00:18 Go to previous messageGo to next message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you placed '/d01/data/forms/fmx' in the 'default.env' formspath?

Re: Call form , can't find the form [message #227067 is a reply to message #226940] Tue, 27 March 2007 04:27 Go to previous message
Messages: 67
Registered: July 2006
Location: Bangalore

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(v_curr_form));

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;

Bhupinder Singh
Previous Topic: Regarding Multiple database
Next Topic: timer not work
Goto Forum:

Current Time: Thu Oct 27 07:54:17 CDT 2016

Total time taken to generate the page: 0.15091 seconds