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 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]......
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 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...
I need to modify an existing form, thus I have to resize a canvas and a window for it. In windows, I run it and I got the right display. When I transfer it to dev server running in linux, then I compile and run it, it display the previous/unmodified size. I'm sure my form is the one that running, I placed some text there and it was displayed.
View 4 Replies View RelatedWe 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 RelatedI have to modify the Form layout of an existing application (Application Express 4.0.2.) where the data for each field is retrieved using SQL statements
Presently the form looks something like this and the Data for each field is rendered properly in this layout:
UNIT # : 123456
ADMISSION #: 2012101510 DISCHARGE DATE: ADMISSION DATE:
FIRST NAME: JON LAST NAME: DOEFIRST NAME, LAST NAME and UNIT # are all "Display Only" item type.
What I'm trying to do is to move "FIRST NAME" underneath "LAST NAME" and "UNIT #" next to "LAST NAME" This part is very simple. However, the issue I'm having is as soon as the "UNIT #" is moved next to "FIRST NAME", the data for "FIRST NAME" and "LAST NAME" simply disappear
This is how it looks
ADMISSION #: 2012101510 DISCHARGE DATE: ADMISSION DATE:
FIRST NAME: UNIT #: 123456
LAST NAME:
I have played around for hours and even created from scratch a new page with a new form using SQL statements to pull the data for each field, only to get the same result.
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'm am getting an error that says that a role doesn't exist when I can cleary see it in DBA_ROLES. I can successfully grant other roles in this session. I am using Oracle 11.1 on RAC.
GRANT "CONNECT" TO BAKERD
Error at line 1
ORA-01919: role 'CONNECT' does not exist
select * from dba_roles where role = 'CONNECT'
[code]....
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.
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 master-detail form I would like to update the emp1 table on the base of current value of dept table deptno and emp table ename .
update emp1
set ename = :emp.ename
where ename =
(select ename from emp e
where e.ename=:emp.ename
and e.deptno=:dept.deptno);
I try the above query but it did not able to update emp1 table.
I have a form with fields like, UserName, User ID Email Address. This is used to create new users & edit existing user information. I wanted to make the Email field mandatory. So i made the email field as 'Required' via Proerty Pallette. So when ever i create new users after this change, i get a message saying 'Field must be required' when i try to skip this email field.
However when i edit existing user information and try to save the data with no email address i am able to save. So, where when i try to save a user info with no email address, i should get a warning saying 'email address is required'. How to go about it and if i wil have to create any trigger.
I am using Forms 6i and developed a Master Detail Oracle Form for Oracle EBS 11i application.
I was asked to write a pl/sql program so that.. When a user updating an existing record at the same time another user query the same record and try to update the same time, the record should be locked and a message should popup saying the record is being updated by another user.
How to call a batch file existing in network path through oracle forms 6i. I am using following code in Forms 6i which is supposed to FTP some .text files to a UNIX box.
Host( '\guww.netdfs.root.Global Shared Data$(LEV)Leven Shared DataLeven Shared DataPublicCOMMONMatsEmpty Bottle ReportsSchedules Preliminaryftp_files_to_ddd.bat');
When I am running this batch file ftp_files_to_ddd.bat from local directory of my PC,it is working properly.
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]....