Forms :: Opening Form Does Not Get Some Of Records?
Dec 9, 2010
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.
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.
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).
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'm using an 'On-Update trigger' to replace the default Form Builder processing for updated records. When I try to change a column in the form I get: ORA- 01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
The on-update doesn't fire. How do I get around this. The block is based on a view.
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'.
When 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.
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 .
I 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.
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.
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)?
After setting up a data entry page,The logic in my page requires that all the records in my tabular form should be displayed .The tabular form is based on a collection, and the user selects rows through a checkbox.Any reload of the page due to pagination will break the logic, as some calculation and display events occur during page load, based on the previous page.
I need to display about 25 rows.I have changed the report attribute to display 50 rows, but it displays rows only up to the bottom of the screen, i.e. 11 rows.
Unfortunately I only just added some new rows and saw this behaviour else I would not have gone that way, as I expected APEX to display all rows if required.
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.
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.
We 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
