Monday, 9 June 2014

Forms Runtime in 10g

In forms 6i we had a forms run time which we used to call the compiled form (ie fmx file)
In Forms 10g I found this is missing

In Forms 6i
To Call a menu
To Call a single form

From Desktop I click on icon as shown below

 

Now it will work in 3 methods
1 Click with form name and Database credentials already in properties
2 Click with form name with out Database credentials
3 Click with out even form name

In First method it will directly open the actual application
In second method it will prompt for Database credentials
In third method it will prompt as below


Now we can browse for the actual FMX file and enter the Database Credentials to run the actual
Application to Work


All these are known things to a persons who have already worked in Forms 6i
Now the Actual Problem is How to run forms run-time in Forms10g
--------------------------------------------------
Even in 10g it is Very simple ,Only difference is it will run in Browser (recommended is Internet Explorer)

 Assume I have created a FMX file in Forms 10g File name is C:\TEST\SQNTRY.FMX
Step1
Ensure OCIJ Instance is Started (Shown as below)

 

Now we can run the forms in 3 methods
1 By Passing only Form name
2 By Passing Form name with Database Credentials
3 By Passing Alias name (where hiding the actual form name and database credentials)

Method 3 is recomended

First Method
http://localhost:8889/forms/frmservlet?form=C:\TEST\SQNTRY.fmx

In Above method it will prompt for Database credentials

Second Method
http://localhost:8889/forms/frmservlet?form=C:\TEST\SQNTRY.fmx&userid=scott/tiger@ORCL

In This Method it will not prompt for Database credentials

Third Method (recommended)
First put a entry in formsweb.cfg as below (Located in C:\DevSuiteHome_1\forms\server)

#Custom config for mytest application
[mytest]
separateFrame=false
lookandfeel=oracle
userid=scott/tiger@ORCL
form=sqntry.fmx

Now call the application as below
http://localhost:8889/forms/frmservlet?config=mytest

DONE

Happy Forms10 Running