Forms :: Any Way To Load A Form Within A Form

May 21, 2010

I have a requirement, is there any way i can achieve the following User Interface using oracle forms

Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.

The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.

View 2 Replies


ADVERTISEMENT

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

I cann't commit form when new instance form with form status is "NEW".

And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"

And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.

View 9 Replies View Related

Forms :: 9i Form To Load Attendance Data

Jan 21, 2013

I want to use SQLLDR (sql loader) in my forms9i form to load attendance data therefore I installed SQLLDR utility in user computer but it is not working,

Begin
:message := 'Please Wait, Data LOADING...!';
Delete From atnd_load;
Forms_ddl('Commit');
utlt:= 'c:oracleora90insqlldr';
usr:= 'vikorapp';
pass := 'vikorapp';
strng := 'laptop';
cntrl := 'C:VikorPayrollFormsAtndCtl.ctl';
lg := 'c: empAtndLog.log';
bad := 'c: empAtndBad.bad';
host(cmd);
:message:= 'Data Loading Complete...!';
End;

View 11 Replies View Related

Forms :: Load Images From Client PC To Form?

Mar 1, 2012

how may I load pictures from Client PC into my form (built in Forms 10g) running on Application Server.I've already configured Webutil package.

View 6 Replies View Related

Forms :: Load Particular Form With Different Width And Height

Feb 10, 2010

i edit forms

web.cfg
width=100%
height=100%

so all applet is loaded full screen in browser.But i want to load particular form with different width and height

View 1 Replies View Related

Forms :: Using Webutil To Get IP Address On Form Load

Feb 12, 2008

My requirement is to show the ip address of the client after he has logged in.

I tried putting the code in when-new-form-instance .. but it returns null. I think the webutil objects are not yet loaded in when the when-new-form-instance is fired. If I put the same code in a push button , I am able to get the IP address. Actually for test purpose I am displaying the IP in a message.

Message ('Client IP add '|| webutil_clientinfo.get_ip_address);

View 5 Replies View Related

Forms :: Reading Data From Excel File And Load Into Form

Oct 25, 2013

I have a Excel File which contains some columns and rows, i need to load that excel into a form and import that form data to Database Table, using DDE Method.

In simple i say; Just to read the excel and load into a form, which can be imported into a table later.

How to achieve this? only dde method.

View 10 Replies View Related

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

[code]......

View 14 Replies View Related

Forms :: Want To Call Web Form For Uploading Image From Custom Form

Apr 16, 2013

I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.

View 1 Replies View Related

Forms :: How To Reload Calling Form After Closing Called Form

Jul 15, 2007

I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.

How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?

View 13 Replies View Related

Forms :: 2 Different Form To Pass Values From One Form To Another

Mar 11, 2010

is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.

View 1 Replies View Related

Forms :: How To Open Another Form Within A Form

Dec 20, 2012

I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.

In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.

This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.

View 2 Replies View Related

Forms :: Pre-form And When-new-form-instance?

Mar 1, 2010

What is the difference and significance of

1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?

View 5 Replies View Related

Application Express :: How To Make Form With Report And Insert Form In Same Page

Dec 14, 2012

how to make a form with report and an insert form in the same page, these two forms are related to the same table. Our customer wants a user can add new row to the table in a form and see all of rows created by this user in a report, this report should provide edit link as well. the problem is: whenever I inserted a new row or edit a row or delete a row, and submitted, and return to this page, all of hidden items lost their values, so report is blank, and some display only items also lost their values.

View 6 Replies View Related

Forms :: Add Sub Form To A Form

Apr 26, 2011

I have a main form of "sales contract". I want to add sub form to take input for commission & shipment details in separate sub forms.

When I click a button on main form, system should open sub form, in which I enter the detail.

View 4 Replies View Related

Application Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?

Oct 31, 2013

I created a master-detail form using wizard in oracle apex 4.2 Now I want to attach an LOV to one of the items of detail form, which is visible on the same window as of master form. To do so, I need to first find the item in detail page, details of which are not available in page definitions. I can see all the items of master form but none for detail form in "Page Rendering" section. 

View 0 Replies View Related

Forms :: Retrieving More Than One Row In Form

Dec 20, 2012

i have created two data blocks

First data data block contains a list item and a text item based on the selection of the list item and the value in the text item i need to retrieve more than one row in another data block whose NUMBER OF RECORDS DISPLAYED property are set to 10.

I have a Button in the first data block. So in the WHEN BUTTON PRESSED trigger i wrote SELECT INTO clause which is raising "exact fetch returns more than requested number of rows".Then i used a cursor in the WHEN-BUTTON-PRESSED trigger in the first block to fetch row by row and assign it to the items in second block. But i am able to retrieve only one record in the second block.

View 5 Replies View Related

Forms :: 6i - How To Link Different Form

Oct 22, 2010

the following problem. am using oracle forms 6i on windows 2003 server.

I have two tables Loan and deduction

Loan(
loan_number number(5)unique not null,
loan_name varchar(15)not null,
loan_type varchar(15)not null,
actual_amount number(10)not null,

[Code]....

Both have loan_number columns as the primary key.

I created two separate forms using loan table and Deduction table.

Also according to requirement, when commiting in the loan form ,if 'loan_purpose' is 'PERSONAL' THEN deduction form SHOULD BE OPENED.

I MANAGED TO DO ALL OF THE ABOVE .

WHAT I WANT IS when deduction form pops up, it should have a matching loan_number as in loan form What shall I do to achieve this???.

View 4 Replies View Related

Forms :: Calculate Sum In A Form?

Nov 23, 2007

how do w calculate sum in a form? for example in datablock sale, I have few rows of data, i want to calculate the total of product purchased (column totitem) and , sum of the customer have to pay. (totalprice). how to do the calculation in a program unit?

View 13 Replies View Related

Forms :: How To Go Through All Items In The Form

Jul 6, 2010

is there any way or loop to go through all items in a form and check them with a condition ???

View 5 Replies View Related

Forms :: Ranking Within A Form?

Jul 25, 2013

I have a query find window that allows you to search on various attributes.Also i have a radio button within the query find that allows you to filter the results either as a single record or mulitiple records For example consider the data below.....

Header Table
Record_Id = 1, Record_No = 'Rec1'

Lines Table
Record_Id = 1, Line_desc = 'Line1'
Record_Id = 1, Line_desc = 'Line2'
Record_Id = 1, Line_desc = 'Line3'

I have a View that joins the 2 tables together so for Record_Id = 1 the view returns 3 rows

I would like to have a query find window that allows you to search using:
Record_No
Line_Desc

and has a radio button to allow you to either show the records as a single line or as all detail lines Therefore i would like the following selections:

1) Enter no search criteria but select Single radio option will return 1 record with default line description of Line1
2) Enter no search criteria but select Multiple radio option will return all 3 records
3) Enter Line_Desc = Line1 with Single radio option brings back one record with Line_Desc = Line1
4) Enter Line_Desc = Line2 with Single radio option brings back one record with Line_Desc = Line2
5) Enter Line_Desc = Line3 with Single radio option brings back one record with Line_Desc = Line3
6) Enter Line_Desc = Line1 with Multi radio option brings back one record with Line_Desc = Line1
7) Enter Line_Desc = Line2 with Multi radio option brings back one record with Line_Desc = Line2
7) Enter Line_Desc = Line3 with Multi radio option brings back one record with Line_Desc = Line3

I need the form to select from the view but then perform a rank after it has selected the relavant data. Then the radio button would use the ranking to select either one record or multi records.

View 4 Replies View Related

Forms :: 6i - How To Know Which User Is Using Which Form

Sep 8, 2011

How to know which user is using which form.I am using form 6i and Oracle 10g a database.

View 3 Replies View Related

Forms :: Simplifying Form URL?

Dec 5, 2009

IS there any way to short the url From

[URL]...

to

{URL]....

View 3 Replies View Related

Forms :: Installed 10g - Not Able To Run Form?

Jan 6, 2011

I installed forms and built a simple form using EMP table.I was able to compile the form successfully but when I run the form it opens IE and says IE has stopped working and closes the program.I have Windows Vista OS and IE7.

View 6 Replies View Related

Forms :: Publishing 6i Form On Web

Jul 16, 2013

I have created a form for data entry in forms 6i and now my requirement is i want to give the access to this form remotely to our branch office , so that we will do the data entry through this form in our database, my query is can this form be published on web , and if yes how to enable it on web or publish it on web so that other users will access them remotely and enter data.

View 7 Replies View Related

Forms :: Key Combination To Get Another Form

Mar 19, 2010

I have a requirement here. User wants when he pressed 'CTRL+E' on the form item, he must get another form. Actually 'CTRL+E' is defined for EDITOR. Then how could I achieve this?

View 2 Replies View Related

Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black

Sep 23, 2011

I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.

Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.

View 5 Replies View Related

Forms :: Saving Form To View On Web

Jan 26, 2010

i have developed a form in 9i. can i view the fmx file on web. or tell me the extenstion what name of form should i use to save the form to view on the web.

View 5 Replies View Related

Forms :: Create Login Form In 10g?

Jun 17, 2011

how to create a login form in forms 10g how upload login.fmb

View 2 Replies View Related

Forms :: Clearing The Form After Commit

Aug 25, 2011

Is it possible to clear the form after a successful commit? In order to avoid the user from double posting of record by making double commit.

View 17 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved