Forms :: Focus Is Not Coming Onto The Form
Mar 31, 2010
The thing is i am generating a report in Excel through forms and excel template in 10g. After generating the Excel trough my code and Macros, i.e save excel, close excel and open excel.
After the excel report which got generated is opened the focus is not coming back to form, it keep on going busy and busy
I tried
form_exit,
go_block and also
Timer:DECLARE
timer_id Timer;
one_minute NUMBER(5) := 90000;
BEGIN
timer_id := CREATE_TIMER('Motor_Timer', one_minute, NO_REPEAT);
END;
etc and etc.
When i am using exit_form, the focus is coming back but the excel is not opening again.
View 2 Replies
ADVERTISEMENT
Oct 3, 2012
I have a form which has a Number field. I set it's Format Mask property to 9,99,99,99,99,999 so that I can format it comma separated and to restrict the user to enter decimal values. If the user enter any format other than this for example any decimal values, it is showing the message FRM-40209:Field must be of the form 9,99,99,99,99,999 which is fine. But when the user enters a decimal value and try to save the form it pop up this message several times.
I tried to catch this error in ON-ERROR trigger and display a message. But this is also pop up several times. I tried to raise form_trigger_failure also. This is also not working. I want this error message to come only once.
View 2 Replies
View Related
Mar 1, 2012
I have two tab like 'TAB1' and 'TAB2'.
Inside TAB1, i have 3 text items and in TAB2, i have 3 text items.
When cursor leave from TAB2's Text Item:3, then focus to be Set on TAB1.
I have used the following coding
go_item(':tabpages.tab1');
But it not working.
How to set the Focus on Tab how to set Focus on TextItem1 in TAB1 from TAB2
View 1 Replies
View Related
Oct 7, 2011
I have created a form in Oracle Forms 6i that utilizes a tabbed interface. Each section of the form has different modules to create a quote on the end page. As far as the logic goes, I have it complete. However, I would like to choose the tab that is in focus, and I can't find a place to change this in the property panel. What am I missing? I don't want it to focus on the last tab which is the totals page, when it should focus on the first page where you enter the data.
View 5 Replies
View Related
Jul 4, 2011
How to focus on current record in oracle forms.
for ex:- I have 10 records in line level.i want to focus my cursor on particular like (5th record) how to possible in form.
Is there any built-in like current_record?
View 4 Replies
View Related
Jul 27, 2010
I have a delete button at the bottom of the form and have two blocks on top of it. I need to know which block i have the focus on or selected the record on pressing the delete button so that I go to that block and do a delete_record from that block. I came across :system.trigger_block which says it gives the name of the block where the cursor was located when the current trigger initially fired. But whenever i use it only returns the name of the block the delete button is located in. Instead i wanted to know where the focus of the cursor was or which record was selected in the above 2 blocks to go to that block and delete the record.
View 1 Replies
View Related
Dec 10, 2010
I have a list item with two values,0 and 1. However when i click on the list item scroll bar appears. My tester is saying for two items she doesn't need a scroll bar.
View 3 Replies
View Related
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
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
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
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
Jun 27, 2012
I was wondering if there is a substitution string ( or something else) that could be used to 'return' the name of a Form item that has cursor focus?
View 3 Replies
View Related
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
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
View Related
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
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
Aug 25, 2013
We have to get some data from U98 (saixdbU98) in UTF-8 format in Excel sheet.We are having queries ready for this. These queries bring data which have Japanese characters.But when we run the Select queries then in the result Japanese chars are garbled. It comes in ????.
let us know what process we have to follow to get the result in UTF-8 format in Excel sheet.here is the code
set sqlblanklines on;
SET DEFINE OFF;
set linesize 1000
set long 1000000
[code]....
View 4 Replies
View Related
Sep 7, 2011
I am using following query to get last 3 month ends. Here If month end falls on weekend(sat/sun) then it should have prior date
Where
COB- Table name
COB_DTE_ID_C- Date in numeric format (YYYYMMDD)
COB_DAY_N- Days
COB_MO_C- Month Number
I am not getting how to modify below query without much case when statements so that if I pass monthend date (20110531), It should give me
20110228
20110331
20110429
Its giving me
20110331
20110429
20110530
select * from (
select DISTINCT MAX (COB_DTE_ID_C) OVER (PARTITION BY COB_MO_C)
from COB
where COB_DTE_ID_C < 20110531
and COB_DTE_ID_C > to_char(add_months(to_date(20110531,'YYYYMMDD'),-3),'YYYYMMDD')
and upper(COB_DAY_N) NOT IN ('SATURDAY','SUNDAY')
ORDER BY 1
) where rownum < 4
View 13 Replies
View Related
Aug 13, 2012
For a couple of employees created in our system, the workflow display name is coming with 'AMERICAN' at the end which clearly looks like is the language setting for the user. ORIG_SYSTEM for this users in WF_LOCAL_ROLES is WF_LOCAL_USERS.
There is no option called WF_LOCAL_USERS in the Synchroinze WF Local Roles program.
View 2 Replies
View Related
Aug 12, 2013
column with datatype Number contains length 1.Its not null.Tried to trim then also length is 1 ....How to find what is the character there..?
View 1 Replies
View Related
Oct 15, 2012
I am using Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production version
I am having the data in following table -
drop table stud_fact;
create table stud_fact(stud_NM, LVL_CD,ST_DT_DIM_KEY,OVRNK) as select
'ABG Sundal','H','20110630','175' from dual union all select
[Code].....
View 8 Replies
View Related
Aug 25, 2013
We have to get some data from U98 (saixdbU98) in UTF-8 format in Excel sheet.We are having queries ready for this. These queries bring data which have Japanese characters.
But when we run the Select queries through pbrun (Power Broker) then in result Japanese chars are garbled. It comes in what process we have to follow to get the result in UTF-8 format in Excel sheet.
here is the code
--
set sqlblanklines on;
SET DEFINE OFF;
set linesize 1000
set long 1000000
set pages 50000
[code]...
View 1 Replies
View Related
Feb 28, 2013
I am using view AB_EV_VIEW created with UNION ALL of 10 tables (ex. AB_EV_1, AB_EV_2.... )
I want to know the data comming in select * from AB_EV_VIEW is from which table ?
Suppose AB_EV_1 is having column ID, NAME
sql> select * from AB_EV_VIEW
100, A1
200, A2
300, A3
400, A4
500, A5
View 3 Replies
View Related
Oct 2, 2013
Grid Version: 11.2.0.3 OS: Red Hat Enterprise Linux 5.6 Node2 of our two node RAC got rebooted. Upon reboot, CRS and ASM instance came up. But the DB didn't come up. How can I check if DB is linked to CRS startup ?How can I enable DB startup upon CRS startup ?
View 3 Replies
View Related
Jun 4, 2013
We have standalone database running on ASM. Its 11Gr2 linux version5 server. After the Database bounce, the DB isnt coming up and is showing the below error.
SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/test/spfiletest.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-00450: background process 'ASMB' did not start
ORA-00443: background process "ASMB" did not start
ORA-06512: at line 4
Also i checked the ASM disk groups. I can see all those are MOUNTED properly. In fact i could also see the spfile present in ASM disk physically. It looks like it couldn't identify the spfile to start up the db. however i could see it physically present in ASM disk group.
Find below snapshot.
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 358400 329103 0 329103 0 N DATA/
MOUNTED EXTERN N 512 4096 4194304 358368 358288 0 358288 0 N FRA/
MOUNTED EXTERN N 512 4096 4194304 20480 18780 0 18780 0 N REDO/
View 3 Replies
View Related
May 10, 2010
i take export of one table (export complet successfully without warnings) when i am going to import into prduction databae the data in the table no coming i past the table structure and import command and logfile for import.
import command
imp user/user@database file=C:Tempuserdrop_id10g _id_rac_ra_headertables.dmp log=C:Tempuserdrop_id10g _id_rac_ra_headertablesimp.log tables=t_id_rac_ra_header fromuser=user touser=user statistics=none ignore=yes
my table structure in production database is
CREATE TABLE t_id_rac_ra_header
(ra_company VARCHAR2(10) NOT NULL,
ra_key NUMBER NOT NULL,
ra_doc_type VARCHAR2(50) NOT NULL,
ra_doc_number VARCHAR2(25) NOT NULL,
ra_doc_date DATE DEFAULT SYSDATE NOT NULL,
ra_reserve_key NUMBER,
[code].....
View 4 Replies
View Related
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
Sep 6, 2011
I have a script which connects to Oracle and return 2 date value. few days back the database was down and when the script execute and return same garbage value in the spool file.
I added a exception handler WHENEVER SQLERROR EXIT 1 befor the connection start and after connection start. But in both the case it is also writing to the spool file.
I would like to exit the connection with a value <> 0 if any connection issue happens like (user id, password, database down error type of issue.) No information should go to the spool file
Output=`$ORACLE_HOME/bin/sqlplus -S /nolog << EOF
CONNECT $Usr/$Pwd@$Server
WHENEVER SQLERROR EXIT 1
spool ${ROOT_DIR}/.delta_date.tmp
[code]....
View 5 Replies
View Related
May 25, 2010
We have quite a number of sessions in database MES (production) coming from another machine.
From v$session, the program is oracle@WID27 (TNS V1-V3). This WID27 (hostname) consists of quite a number of development databases inside. We have to trace which jobs are actually triggering this, as WID27 are not suppose to connect to production databases.
How can we tell whether the sessions came in is from dblink or from the machine itself?
View 3 Replies
View Related
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
