Forms :: Getting Data After Pressing TAB In INSERT MODE In 10g?
Nov 9, 2010What to write in a form for getting data after pressing TAB in 'ENTER-QUERY' MODE on a field having a LOV i.e. a trigger / program unit or what?
View 12 Replies
ADVERTISEMENT
Forms :: Sort Data In Execute Query Mode During Runtime?
Nov 15, 2012How can i sort data in the execute Query mode during runtime,i have a columns which has number, char and date field.
This below data is fetched in execute query from a table;
x1 x2 x3
1343 adfa 11/14/2012
1353 adfa 11/11/2012
1333 adfa 11/10/2012
1333 adfa 11/12/2012
1353 adfa 11/09/2012
now i like to sort like this below;
x1 x2 x3
1343 adfa 11/09/2012
1353 adfa 11/10/2012
1333 adfa 11/11/2012
1333 adfa 11/12/2012
1353 adfa 11/13/2012
how to do it?
Forms :: When Insert Detail The Data Insert Twice Time
Feb 27, 2012when i tried to insert the details from oracle froms..the data inserts twice to the DB..
my table structure:
create table app_sri
(a_id integer primary key,
p_first_name varchar2(30),
p_last_name varchar2(20),
p_age number(3)
);
here a_id can be genarated through simple sequence(pid_seq)...
trigger on app_sri
create or replace trigger pid_trg
[Code]....
form insertion code..
Begin
insert into app_sri(null,'robo','Big',100);
commit
End;
the data inserted...but twice
what is the reason behind the double insertion?
Forms :: Execute Query By Pressing A Button
Dec 22, 2011I have two data block but i want to execute_query () ; by button when i press the button one data block record display
View 4 Replies View RelatedForms :: Pressing On A New Record - Error Frm-41009?
Jul 2, 2011I have a button which leads me to a calendar and when I enter the record and when I press on a new record and I begin entering the other record this error frm-41009 appears to me so what can I do to get it over?
View 1 Replies View RelatedForms :: 10g - Runtime Process Freezes On Pressing Button
Feb 20, 2010I am using Oracle Forms 10G and I have a button that calls a form in my app by using the
new_form('FRMINIT.FMX'); statement.
When I press the button the runtime process freezes and it does nothing. When I hit Ctrl+Alt+Delete the frmweb.exe process raises its kbs in memory.
In the past i solved that problem. It was caused by a setting the parameter serverApp in the formsweb.cfg to the correct value (serverApp=[URL] ....) but i tried this again and although it is correct the runtime process freezes. Plus, i do not get an error message in JInitiator Console.
Here is my formsweb.cfg configuration file:
[kerberos]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
[Code] ............
Forms :: Show Increasing Digit 1 To 100 In Text Field After Pressing One By One
Aug 26, 2013the code for show increasing digit 1 to 100 in a text field after pressing a button 100 times?
View 26 Replies View RelatedForms :: Fields Disappear / Hide After Pressing Execute Query?
Feb 15, 2010Something strange happens when i give execute query in a form (Oracle Forms 10g.). On executing query, one field disappeared but when i clicked on the location of the field it appeared again. I am not sure if this has something to do with visual attributes/display properties. This is happening only after migration to 10g.
View 7 Replies View RelatedForms :: Enable A Button - Capture Trigger That Fires On Pressing Exit
May 23, 2011I have a situation where one form calls another. I am opening the other form(say B) using the below code.
declare
temp_form formmodule;
begin
temp_form := FIND_FORM ('D:RSSQ2TestingpurposesMODULE3_MULTIPLE');
[code]...
On Form B there is an Exit button on click of which it closes the Form B and returns to Form A
begin
close_form('MODULE3_MULTIPLE') ;
end;
In my scenario on Exit from FORM B i need to enable a button on FORM A.I am not able to capture the trigger that fires when I Press the Exit
Forms :: Insert / Update Data
Oct 12, 2010check my query and correct it basically I want to insert/update data from one user to other therefore I write this coding at my form button, when user press button first time its insert data successfully but if user press button again then it should update because data have been inserted in first step.
Actually it is detail table so it can have more then one record against any master. My query fails in updation, it inserts a new record instead of update.
find the attached file for checking QUERY.
Forms :: Insert Data And Then Update Table
Aug 5, 2010i have a tabular form select * from emp and i want to create table and store there data in goup select empono,sal,com group by dept i want to insert in another table.
how i insert the data in table by forms front end and then update also when again click the button or any change occur in form insert into a select empono,sal,com group by dept
Forms :: How To Insert Data In Two Table In Same Time
Feb 4, 2012how to insert data in two tables in same time
table1 --master table
table2 --transaction table
Forms :: Updating - Insert Some Data In Transaction Table
Feb 1, 2011i want to insert some data in the transactions table on after insert trigger. Which trigger should i use on form level to accomplish this task.
View 4 Replies View RelatedForms :: Insert DATA In Database In Uppercase Format
Mar 19, 2013I have a datablock based , I used commit_form(); to insert data in my DB .But,I want to insert data into my DB on uppercase format!!
View 3 Replies View RelatedServer Utilities :: Insert Data Without Writing Insert Statement In Oracle?
May 15, 2010how to insert data in oracle table without writing insert statement in oracle 9i or above. i am not going to write insert all, merge, sqlloder and import data.
View 2 Replies View RelatedData Guard :: What Is The Most Common Mode
Feb 27, 2012what is the most common mode in dataguard? maximize protection or maximize availability or maximize performance
View 6 Replies View RelatedForms :: Run 10g In Mode Debug?
Jan 5, 2012I want to run form 10g in mode debug, however when i set break point in code and press shift+ F9 ( or run Debug by click icon on Form 10) then Form still run but not run in mode debug. Now i want to run form 10g in mode debug, how do i do?
View 2 Replies View RelatedData Guard :: ORA-01102 / Cannot Mount Database In EXCLUSIVE Mode
Apr 28, 2003How i create Standby Database in Same HOST, we using SUN OS 5.8.
I read form Oracle DOC that i can create Standby Database in Same HOST and follow the tutorial , but when i try to mount standby database using ALTER DATABASE MOUNT STANDBY DATABASE EXCLUSIVE; i got a error message ORA-01102: cannot mount database in EXCLUSIVE mode
Data Guard :: LGWR Sync - Maximum Availability Mode
Mar 10, 2013I have few queries regarding standby database.
1)On primary Database Standby Redo log is required for switchover and on standby database Standby Redo log is required for
--Real time Apply
--Maximum protection or Maximum availability
Am I correct?
2)My database is in Maximum Performance mode. I set up following entry on init.ora:
LOG_ARCHIVE_DEST_2='service=standby LGWR ASYNC'. My question is do I need to have STANDBY Redo log file on standby database in order to use LGWR transport (LGWR ASYNC)mode from primary? Without Standby redo log on standby database can it transport redo data from primary to standby using LGWR transport mode (LGWR ASYNC)?
3)I have changed from the "ARCH" attribute to "LGWR" attribute of the LOG_ARCHIVE_DEST_n initialization parameter. But I have not changed the protection mode. I would like to know whether is there any impact in the behavior of the database, if we do not change the mode from "MAXIMUM PERFORMANCE" to "MAXIMUM AVAILABILITY"?
Data Guard :: Oracle 9i - Cannot Mount Database In EXCLUSIVE Mode
Jun 30, 2008I'm trying to create a physical standby database on my Oracle9i DB runing on WinXP.
Note: I have both Primary and Standby on the same system.
Actually everything went well .... I did created the standby DB but the problem is I can not start my primary DB if my standby DB is mounted. I get this error:
ORA-01102: cannot mount database in EXCLUSIVE mode
And when I read about the error message I learnt that I should start my DB in compatible mode ...
Forms :: Compressed Mode Using Text_io
Jun 14, 2011When I used to work with foxpro we had used dot matrix printer. At that time if we want, we can print in normal mode, expanded mode and compressed mode. it will be part of your spool file.
Now am printing a text file from forms using text_io package. I would like to know in this how do i print the content in compressed mode using CHR function or some other method.
Forms :: Default Mode While Entering?
May 25, 2010Is there any property that can be set at design time or dynamically altered during runtime about the default mode in which a form opens? I have created a new FORM in Forms 6i and it opens in the Enter-Query mode. I do not want to open it in the Enter-Query mode. This is because I will be doing my own execute_query on some click of a button in the form. How do I alter this Enter-Query mode in which the form opens?
View 2 Replies View RelatedForms :: Calculation Mode With Conditions
Sep 24, 2013I have 2 fields f1,f2
I define f1 a summary in calculation mode
I want to sum f1 where f2 = 5
Forms :: How To Change Updatable Mode
Jul 18, 2011how to change form in updatable mode?
View 1 Replies View RelatedData Guard :: Apply Redo While Standby Open In Read Only Mode?
Apr 9, 20131) If i do changes in table on primary database and if i open standby database in Read-Only mode, i can see those changes immediately only if Real Time Apply is enabled. Am i correct? Database version is 10.2.0.4
2) From 11g, It is possible to apply redo while the standby is open in read only mode. prior to 11g, it was not possible. Right?
3) Should I first cancel Managed Recovery prior to issuing “ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY”?
Forms :: How To Cancel Enter-Query Mode
Aug 31, 2011When i entered for modification/deletion process initially i prefer to entry-query mode then execute the query.
Suppose when i am in entry-query mode but i want to cancel(abort) the mode ie. entry query. How to achieve this.
Forms :: Close A Window In Query Mode
Apr 10, 2010How do I close a window in query mode?My form has a button "Populate from Charge Master" which opens a window containing a List Item (Department Names) and 2 buttons,
1. "Select the Dept" and
2. "Cancel"
The WHEN-BUTTON-PRESSED trigger code for "Populate from Charge Master" button is as follows:
begin
SHOW_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
go_block('bl_med_dep');
enter_query;
end;
Code for "Select" button in the window is:
populate_from_charge_master(:bl_med_dep.med_dep_code,:bl_med_charge_party.charge_party_no);
execute_query;
COMMIT;
HIDE_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
GO_BLOCK('BL_MED_CHARGE_PARTY');
EXECUTE_QUERY;
Code for "Cancel" button in the window is:
BEGIN
hide_window('WINDOW_POP_FROM_CHARGE_MASTER');
show_window('WINDOW1');
GO_BLOCK('BL_CHARGE_COMPANY');
END;
Here WINDOW1 is the main window and WINDOW_POP_FROM_CHARGE_MASTER is the window which must be closed when "Cancel" button is pressed.
When I remove "enter_query" statement in "populate from charge master" trigger code, I am not able to select any of the departments from the list. and If I have that statement, I am not able to hide/close the window.
Forms :: How To Make Query Mode Work (f11)
Apr 2, 2012I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.
View 18 Replies View RelatedForms :: A Button Has To Be Disabled In Query Mode (F11)
Apr 3, 2012Am developing a custom form. I have a block with 5 Items and one button(SUBMIT). When I go in query mode (F11), SUBMIT button to be disabled. How do i achieve this.
View 22 Replies View RelatedData Guard :: How To Find Applied_time In Standby Database Managed Recovery Mode
Sep 10, 2012How to find applied_time in standby database managed recovery mode (*PHYSICAL STANDBY*).
View 3 Replies View Related