I have a multiple forms application and I use OPEN_FORM to call one form from another. However I want the new form to open in a separate tab ( the way it works in a tabbed canvas).
View 4 RepliesIf 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]......
There is a existing form B. From a form A I need to call form B on button press. Problem is form B has many tabs,It should open in the third tab when it is being opened from form A.
View 1 Replies View Related I have developed a new form.Something peculiar is happening for that form.Let me list down the scenario
1)In the data base for the particular table my form is using, there are 1600 records.When i do a Query on Count Hits in the forms,it gives the same number.
2)However when i open the form ,i do not get some of the records.I found that on opening the form and making an Execute Query only those records that i have added through forms exist.
3) However,when i try to add a new record and do an Execute query again,i get all the records present in the database.
My client is Oracle 10G DS Forms Developer. The application server is on a Solaris 64 bit sparc system. I have copied all the forms and libraries to my forms directory under C:DevSuiteHome_1forms10g_rel1 from the application server. and placed the following directory in my FORMS_PATH in the registry entry.
Now I am opening up the forms in my Forms builder and running the form. I get this error. I have the attached library in the form but I still get this error:
FRM-40039 Cannot attach a library while opening a form
I have installer oracle 11i database, with oracle 10g forms for development.When I am trying to open test form in oracle 10g form only Internet explorer is opening with blank screen, while it is connected to oracle database (version 11i).
Oracle 11i is on windows 2003 ent server and Oracle 10g is on windows 2000 professional...
We have a problem while opening PDF through oracle forms, we are getting the folowing error in some PC's, but some PC's this is working fine.'there was a problem reading this document 14'.
View 5 Replies View RelatedWhen I click on 'Run Form', the Applet is not opening in Internet Explorer.
Giving Error like " Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience."
Even I have re-installed the oracle 10g the same problem is coming.
Note: When I remove jinitiator and then reinstall jinitiator the applet is opening once and again if I run the form second time the same above error is coming.
How to work on forms without opened oc4j..
am working on 10G .. Forms 10G
am using the OC4J for the oracle FORMS 10G to me the engine for woring maybe about 20 client ..
my question :
1- if am close the OC4j the forms closed ?
2- how to work forms to be like off line if the oc4j is closed and working tell before save .. ?
I would like to ask a very small question. what is the code that should be written to open a picture inside the button.
I have already made the button, and the trigger is when push button, what I want is when I click the button it opens a picture in this directory:
F:AmjadAmjadamjad1.jpg
the name of the picture is taken from table1 the colum serial_number
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.
I need is to generate this chart automatically from the form builder without opening any program like visio (for instant). that's mean when I select the wanted department the chart will be generated automatically .
View 9 Replies View RelatedI want to display different forms in one Frame/ canvas.when I press button Inventory then In the frame/canvas it should display Inventory form in the frame.If i press Employee it should display Employee form in frame.
View 1 Replies View RelatedWe are using oracle forms 10g, in formsweb.cfg file i gave separeteFrame=true and it works fine also like IE & applet window is opening. But User wants to hide the IE in backegroud and they want only applet window, so using VBScript we are hiding the IE and now only applet window apears this also fine.
I am running the report and displaying the report using web.show_document, report is running fine and displaying in IE with PDF format. But the problem is if i press the run report button report is opening and displaying behind the applet window not infront of applet window and there is no focus on the report IE also. How to display the report output(IE with PDF format) infront of the applet window and current focus on the report window(IE with PDF).
Note: If i use separateFrame=false then report is displaying infront of the IE screen and focus is on the report IE.
I have some .fmb files in 'F: ask" " ' location.and my question is can i store the .Fmx files in other location like 'D:" " '
that is if i create a .fmx file for the 'F: ask**.fmb'. i want That .fmx file will store into other location i.e 'D '
I want to capture date and time in separate fields from user and save it in single column in table
example: user enters date and time
Date : 08/05/20212
Time : 18:50:00
At the time of save I want to save [08/05/2012 18:50:00].
I have 2 tables T1, T2
T1 is having 2 columns t1_c1, t1_c2
T2 is having 3 columns t2_c1,t2_c2,t2_c3
I need to design a form which should be like
there must be a pop item (Dropdown menu) in a separate block.
If I select 1 from the pop item,
T1 with 2 columns should display in a tabular form.
If I select 2 from the pop item,
T2 with 3 columns should display and T1 with 2 columns should hide.
So the form should be dynamic based on the selected pop item. Is there any chance to do this?
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 RelatedI 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)?
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 RelatedI 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.
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.
What is the difference and significance of
1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?
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.
un-documented parameter _trace_files_public / I want to set this to true so my app team can review trace files. better way to proceed to open read permissions for non oracle users.
View 2 Replies View RelatedWe have cloned the db and after opening the db with resetlog option we came to know that one of the user db file is not part of the db and is showing the below error while checking the status and attempting to online it. When checking the size and availability of the dbfile it shows everything without errors.
SQL> alter database datafile 50 online;
alter database datafile 50 online
*
ERROR at line 1:
ORA-01122: database file 50 failed verification check
ORA-01110: data file 50:
'+DATA/orcl/orcldata.291.730828357.dbf'
ORA-01251: Unknown File Header Version read for file number 50
I'm new to Oracle. I took cold backup of my database. Then, i removed my whole database while database was down.Then i restored the whole database from backup taken earlier. Now, when i try to open the database. it does not open up instead gives the below message.
Total System Global Area 1288949760 bytes
Fixed Size 1336288 bytes
Variable Size 754977824 bytes
[code]....
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.
I want to generate the gapless montly running balance for the whole year.Data in the table "A" is as below.
code Date amount remarks
0101 30-SEP-10 1000 Opening
0101 01-OCT-10 1500
0102 25-OCT-10 500
0102 10-DEC-10 750
0101 26-JAN-11 450
0102 03-MAR-11 3000
0101 30-SEP-11 6000
Required output is
Code Date amount Balance
0101 31-OCT-10 1500 2500
0101 30-NOV-10 0 2500
0101 31-DEC-10 0 2500
0101 31-JAN-11 450 2950
-- -- -- continue
0101 30-SEP-11 6000 8950
Same output for code 0102. I have taken only 02 code for excample only. There are about 250 code in table.
we have a database available in UNIX machine A which can be connected from client in UNIX machine B through port 1521.
If we give ping command from UNIX machine A to B or B to A, 0% packet loss, means connection established properly through firewall in port 1521.
Now we are setup one more UNIX machine C and installed a client here. This machine is available in different group, means if i give ping command from machine C to A, 100% packet loss. But from machine A to C, connection established with 0% packet loss.Because of this, when we tried to connect to a database from client in Machine C to database in Machine A, we got "time out" error.
My query is:
1. Is this because of not opening of port 1521 through firewall?
2. If so, is it enough to open port 1521 through firewall when we connect from machine C to A?
3. Any additional setup is required in firewall apart from opening of ports?
Environment:
Oracle 11.2.0.3
UNIX AIX 5.3/6.1