Forms :: How To Get Current Cursor Position In Oracle 10g Form

Feb 25, 2010

I want to get current mouse cursor position dynamically,what should i do.

View 3 Replies


ADVERTISEMENT

Forms :: Insert Value Into Text Field On Current Cursor Position?

Sep 30, 2013

I need to copy some text value in to a multi-line text item on the current cursor position.

View 8 Replies View Related

Forms :: Parametrized Cursor In Oracle Form

Dec 7, 2011

I am creating a button , on this button i call a procedure

e.g. excel

on this procedure i call parametrized cursor ...but i give me error i dont know what is this ..my code is like this

Quote:
PROCEDURE excel IS
CURSOR C2(v_link_nm varchar2) is
select alt_loc LOC, alt_inv_no INV_NO, alt_inv_dt INV_DT, alt_amt AMOUNT, alt_rvc2 ALT_RVC,
alt_doc_no DOC_NO, alt_doc_typ DOC_TYP, alt_authid AUTH_ID, alt_authdt AUTH_DT
from v_link_nm
[code]......

when i compiled i get error v_link_nm not defined...

View 1 Replies View Related

Forms :: Cursor (control) On Current Record

Jul 18, 2011

In my form line level block contains 100 records.i will check the check box for line number 96 and 97. Then i will press save(I have written some logic here) button it will generate one number for selected check boxes. After generating this number cursor(control) should be on same line number 96 or 97.

View 10 Replies View Related

Forms :: Click Checkbox And Then Loop - Current Cursor Going To Last Record

Dec 7, 2010

i m using oracle 10g 10.2.0.2 version.i create a form and using check box on this form.when i click this check box then loop is using behind it.and current cursor is going to last record

i want if i click 4 record then cursor is still showing on 4 record mean i click which record after using loopmy current cursor is showing on that particular record

how it is possible

View 1 Replies View Related

Forms :: Calling From Other Data Block Into Current Master / Detail Form

Jun 10, 2013

I got the following scenario.

- A Master/Detail form which is called from previously saved table.
- In the detail form, user is allowed to insert list of data from other block into the current detail form. For that I have one when_button_pressed with the following script define :-

Begin

go_block('ACT_VW_QT_ACTV'); <----- query block
FIRST_RECORD;
IF :BLOCK44.ITEM45 IS NOT NULL THEN
:BLOCK44.ITEM45:=:BLOCK44.ITEM45|| ' OR ';
END IF;
[code].......

When this is none, nothing being happened on the current block ( 'ACT_QT_TXN1'), I think it is because of the master/detail link where it always looks back the original link data. I think this is very common problem but I just can't figure out how to go about it.

View 1 Replies View Related

SQL & PL/SQL :: Identifier In CURRENT OF Clause Is Not Cursor Name

Jun 30, 2011

set serveroutput on
declare
type curs_type is ref cursor;
rec employees%ROWTYPE;
curs curs_type;

[code]...

It gives the error "identifier in CURRENT OF clause is not a cursor name" even though the identifier "curs" is a cursor name

View 3 Replies View Related

Does Column V$SQL.CHILD_NUMBER Related On Number Of Current Cursor Only

Jan 11, 2013

Does the column V$SQL.CHILD_NUMBER related on number of current cursor only ? V$SQL lists statistics on shared SQL areas without the GROUP BY clause and contains one row for each child of the original SQL text enteredI see in V$SQL big numbers in V$SQL.CHILD_NUMBER ( HASH_VALUE and PLAN_ HASH_VALUE is in my quewry fixed ) , am I wrong that this column displayed not summary count of "objects"(in terminology of Steeve. URL....

View 0 Replies View Related

Forms :: How To Know Operating System Current Path In Oracle 10g Forms

Apr 19, 2011

How to Know Operating System Current Path in oracle 10g forms ?

View 4 Replies View Related

Forms :: How To Focus On Current Record In Oracle

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

Forms :: How To Position Center Customized Logon Screen In Web Forms

Nov 20, 2012

I would like to Center Align application login page(Syslogin) oracle froms 11gr2. The below code is not working in forms 11g2, it's working in Forms 6i

PROCEDURE CenterWindow (win_name VARCHAR2) IS
w_mdi NUMBER;
h_mdi NUMBER;
w_win NUMBER;
h_win NUMBER;

[code]...

View 3 Replies View Related

Forms :: Calendar LOV Position (x / Y) On 6i

Aug 1, 2011

I have included a calender control in my form and its working fine.Now, my problem is how can I automatically place the calender next to the text-item (for example, "block.invdate")if the push button is pressed to call a calender.

View 1 Replies View Related

Forms :: SQL Server In Stop Position?

May 25, 2011

SQLserver in stop condition when i play it. it again stop

View 1 Replies View Related

Adding Time Part To Current Date To Form Timestamp

May 17, 2011

I have a column where I have time stamp with date and time(8-May-10 10:20:55 Am) from that i will get only time(10:20:55 Am)[query for this mentioned below] Now i need to append the time to current date and insert into a Timestamps column only .

so my result should be 17-May-11 10:20:55 Am(Assuming current Date is 17-May-11) . I tried search it by i found a way in sql server by using DataAdd and DataDiff .

query to get the time is:select to_char(to_date('11-MAY-11 05.00.00 PM', 'DD-Mon-YY HH:MI:SSAM'),'HH24:MI:SS') "Time Now" from dual

View 1 Replies View Related

Forms :: How To Handle Position / When Do You Want To Save Changes / Dialogue Box Appears

Jan 22, 2013

I am working on Oracle apps. I have developed a custom screen. On the screen, if the user press 'F4' on final step, it will ask the dialogue..Do You want to save changes?

Yes No Cancel.

Even the user press the "Yes" , I want to check my own validation and commit when my validation get perfect.

View 1 Replies View Related

Forms :: Customize Position Of ALERT Message On Screen As Per Requirement

Mar 19, 2010

I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.

View 4 Replies View Related

Forms :: Setting Mouse Position And Restricting Checkbox Update?

Aug 9, 2010

what name is used to reverence the mouse cursor in Forms. I am trying to state that if the user reaches the last record in a file and clicks the mouse on the empty record below that they will get a message saying they are at the last record (basically so it means they have to manually click an add record button before they can add a new record)

I currently have this:

IF :SYSTEM.LAST_RECORD = 'TRUE'
THEN
<something here> := :SYSTEM.LAST_RECORD;
MESSAGE('You are at the last record.');
ELSE
DOWN;
END IF;

Where i have <something here> is where i assume the refence for the mouse cursor should go, of which i dont know the name, am i correct?

Another thing is that I have a checkbox that is originally NO but when set to YES cannot be turned back to NO.

I have accomplished this by putting the following code in the WHEN_CHECKBOX_CHANGED trigger and it works fine. However it also updates the checkbox to NO and then back to YES, , as a result this brings up my Are you sure you want to update message. I originally thought that if i took out the :in_active := 'Y'; the FORM_TRIGGER_FAILURE would stop the checkbox being changed in the first place but this didnt appear to be the case. how to accomplish this without letting it update at all (perhaps put something in the WHEN_VALIDATE trigger?

DECLARE
return_alert number;
BEGIN
if :in_active = 'N' THEN
return_alert := SHOW_ALERT('checkbox_alert');
:in_active := 'Y';
RAISE FORM_TRIGGER_FAILURE;
END if;
END;

View 5 Replies View Related

Forms :: Trigger That System Generate Position Against Total Marks?

Aug 26, 2011

i have one project about school system.there is one column of total marks.and other one is position column.i want a trigger that system genrate the position against total marks. problem is this when total marks become equal for example 101 and 101 than position also same.but dont now what a trigger i write for this.here some example

if total marks 100 than position is 1stand if total marks 99 than position is 2ndbut third person is also same number in total marks column i mean 99 than in position column must write the 2nd

View 4 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

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

Forms :: Get Data From Ref Cursor On Oracle Forms?

Mar 14, 2012

How can i get data from Ref cursor on Oracle forms?

View 1 Replies View Related

Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black

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

Forms :: Unable To Use PARAMETRIC CURSOR In Oracle

Sep 21, 2011

Need PARAMETRIC CURSOR EXAMPLE with fmb i am unable to use PARAMETRIC CURSOR in oracle forms.

View 1 Replies View Related

Forms :: Migration Of Oracle Form 10g To 6i?

Apr 19, 2011

Is this possible to convert oracle form which developed in oracle form 10g into Oracle form 6i. We developed one form in oracle form 10g and we trying to open it oracle form 6i. At start it gives warning about compability by ignoring this it open in form 6i, but control mismatch and not showing the trigger code that type of problem we faced. tool of that convert the oracle form 10g into 6i.

View 1 Replies View Related

Forms :: Matrix Form In Oracle

May 20, 2013

Is there any possibilities to make matrix form just like matrix report.

one is the month column which increase horizontally other is emp_name column which increase vertically and sal column which show the salary of each employee in each month.

View 1 Replies View Related

Forms :: Why Other Browser Cannot Run Oracle Form Without IE

Oct 9, 2012

Why Other Browser cannot run oracle forms without IE.

i want to use other browser for oracle form like firefox,google chrome etc not IE.

View 11 Replies View Related

Forms :: How To Convert Oracle 10g Form To 6i

Oct 24, 2013

How to convert Oracle 10g Forms to Oracle 6i Forms ?

View 2 Replies View Related

Forms :: Oracle Form Entry?

Feb 25, 2010

i am new to oracle form , i am using orcale 10g forms, i have following requirements.

1-I have a Data Block names Hes_Modules which is connected to a table HES_MODULES having following fields (modid,moddescr).

i want when form open it should show all enteries in table, My form conatin 5 fields and scrollbar.After form open it should allow to update and insert the reords in form

View 3 Replies View Related

Forms :: How To Run Oracle Form Server 10g From IPhone

Sep 27, 2013

How to Run Oracle Form Server 10g From IPhone

View 3 Replies View Related

Forms :: Create Directory With Oracle Form PL/SQL

Jan 16, 2010

i want to know how to create directory or folder which use pl/sql coding in oracle developer suite10g

my problem is when i use this code

trigger WHEN-BUTTON-PRESSED

EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY'||'C:RESTAURANT';

IT'S ERROR WITH "Error591 this feature is not supported in client-side programs"

I used to use function with webutil that's webutil_file.create_directory('c:RESTAURANT');

trigger WHEN-BUTTON-PRESSED

WEBUTIL_FILE.CREATE_DIRECTORY('c:RESTAURANT');

BUT STILL HAVE ERROR WITH "Error 221 'CREATE_DIRECTORY' is not a procedure or is undefined "

How to create directory with pl/sql that's use in oracle form in trigger when-button-pressed or how to use function webutil_file.create_directory();

View 9 Replies View Related

Forms :: SQL Server And Oracle In A Single Form

Apr 23, 2011

can I query sql server and oracle in a single form

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved