Forms :: Insert Value Into Text Field On Current Cursor Position?
Sep 30, 2013I need to copy some text value in to a multi-line text item on the current cursor position.
View 8 Replies
ADVERTISEMENT
Forms :: How To Get Current Cursor Position In Oracle 10g Form
Feb 25, 2010I want to get current mouse cursor position dynamically,what should i do.
View 3 Replies View RelatedForms :: Cursor (control) On Current Record
Jul 18, 2011In 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 RelatedSQL & PL/SQL :: How To Write Text At Specified Position In File
Apr 11, 2013suppose i have a file named chk.txt and I have write 10 line in that file and i just want to write some text at line 5 or line first then how we can do this ?
View 3 Replies View RelatedForms :: Click Checkbox And Then Loop - Current Cursor Going To Last Record
Dec 7, 2010i 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
Forms :: Make A Field As Mandatory At Current Record Level
May 27, 2010I have one requirement i.e i want to make a particular item as mandatory for the current record in the tabular form.
so i have written code as below:
DECLARE
lv_item item;
BEGIN
lv_item := FIND_ITEM ('XXMZ_DETAIL.QTY_ACT');
SET_ITEM_INSTANCE_PROPERTY (lv_item,
current_record,
required,
property_true);
END;
This code is not effecting qty field. If i write set_item_property built-in that item becomes mandatory.But it's not effecting at current record level.It's effecting block level.
So how can i make a field as mandatory at current record level?
SQL & PL/SQL :: Insert Comma After 3rd Position In String Value?
Jul 29, 2013I have to convert string 1234567 as 123,456,7 .
note 1234567 is a string.
Forms :: EBS Form Text Field Enable
Jul 17, 2013I am working on oracle ebs r12 and wants to enable text field (amount column in attachment) which is disable into form. How can i meet this requirement.
View 3 Replies View RelatedForms :: Text Field Prompt Displays?
Jun 2, 2010Text field prompt displays ? while using bengali language but text field displays value in bengali language when retrieve data from database.
I am using oracle 11g database in windows platform and oracle 10g application server release 2 in linux(rhel 4) platform. For client machine I am using windows xp and jre version 6 update 14
To do this I add following line into user bash profile in application server:
export NLS_LANG=AMERICAN_AMERICA.UTF8
I also edit oracle_home/forms/java/oracle/forms/registry/Registry.dat file as below:
...
....
#default.fontMap.defaultFontname=Dialog
default.fontMap.defaultFontname=SolaimanLipi
Forms :: Multiline Data / Showing In One Text Field
Mar 1, 2011I have got data in a table like
ID Service
1 A
1 B
1 C
I have written a cursor which is fetching it like A,B,C and assigning it in a display field.
It is working fine.
I want to display it in single text field but in multiple lines.i have set the property multiline to yes in property insepector.
I want to display it like
A
B
C
but it should remain in single field/text box. Infact i am unable to break the line in cursor.
Forms :: Enter Arabic In English Text Field
Apr 24, 2013I have a problem in Oracle Forms 10g. For any field that should be by default right-to-left (arabic), the reading order is changed when entering the field, but the keyboard is not changed to Arabic automatically. The user has to type ALT+ Shift to manually modify the language.
I worked before with Forms 2000 and Forms 6i (in client/server mode only), it was working fine. Is it impossible on Web Forms? Must I use a Java Bean? If yes, is there something existing to perform what I need?
Forms :: Fetching Background Color Of Text Field?
Jul 29, 2013i want to fetch the background color of my text field
i am using
Get_Item_Property('TEXT1',BACKGROUND_COLOR)='r0g127b127
is this valid? if yes then its not working here.
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 :: How To Insert Bullets In Text
Dec 21, 2010I am using oracle database 10.2.0.1.0 with oracle developer 10.1.2.0.2 on windows xp.I have a assignment in which i have to insert data in text field using bullets.Means user would like to use bullets while inserting data in text field.How can i use bullet option (as we have in MS word) in oracle forms.
View 5 Replies View RelatedForms :: Changing Visual Attribute Of Text Field On Mouse Over In Oracle 9i
Apr 5, 2010I m using oracle forms 9i in which i want effect on text fields that will change color of text after mouse cursor move on that field . is it possible in oracle form 9i .
View 6 Replies View RelatedForms :: ORA-01403 Value Will Be Sitting According To Post Trigger Of Previous Text Field
Jul 26, 2010I have sort button that have the following code
go_block('TEL_OTHER_INFO');
set_block_property('TEL_OTHER_INFO',order_by,:system.cursor_item);
execute_query;
I have in the same form display item that its value will be sitting according to the post trigger of the previous text field when i press the sort button i get frm-40735 post-text-item unhandled exception Ora-01403 error.
Forms :: How To Insert Column Values Into Text Items
Dec 30, 2011I have created the Textitem with five instances.
i am trying to assign column values to text item through query.
if my table contain one record,it shown in textitems.But if my table contains more records it is showing ora-1422 err.how to solve it.
Forms :: Insert Image Into Database Field By Scanner / Camera
Jul 7, 2011i'm using form 6i and oracle databse 10g i want to insert an image into database field(BLOB) from scaner or camera
i have been search about this in this forum but no thing
any example
My Email :[URL]....
SQL & PL/SQL :: Identifier In CURRENT OF Clause Is Not Cursor Name
Jun 30, 2011set 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
Reports & Discoverer :: Current Date Field
Sep 13, 2010if i make the source for a field is a current date with format dd/mm/rrrr hh:mi:ss and the report published on the application server and the clients from different machines run this report
what the field display on Cline or on DB or On Application Server?
Does Column V$SQL.CHILD_NUMBER Related On Number Of Current Cursor Only
Jan 11, 2013Does 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 RelatedForms :: How To Position Center Customized Logon Screen In Web Forms
Nov 20, 2012I 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]...
Forms :: Calendar LOV Position (x / Y) On 6i
Aug 1, 2011I 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 RelatedForms :: Read Data From Table And Insert To Another Table With A Cursor?
Feb 20, 2013I have a table with a BLOB column ;
I want read data from table and insert to another table with a cursor
My code is :
procedure read_data is
cursor get_data is
select id,image from picture1;
id1 number;
pic blob;
begin
open get_data;
[code]....
when I run form , error FRM-40734 occurred
error in line " fetch .... "
Forms :: SQL Server In Stop Position?
May 25, 2011SQLserver in stop condition when i play it. it again stop
View 1 Replies View RelatedForms :: How To Handle Position / When Do You Want To Save Changes / Dialogue Box Appears
Jan 22, 2013I 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.
Forms :: Customize Position Of ALERT Message On Screen As Per Requirement
Mar 19, 2010I 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 RelatedForms :: Setting Mouse Position And Restricting Checkbox Update?
Aug 9, 2010what 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;
Forms :: Trigger That System Generate Position Against Total Marks?
Aug 26, 2011i 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
SQL & PL/SQL :: Reading BLOB Field To REF Cursor
May 27, 2011I have a procedure which will be called my front end team get the reports stored in the database as BLOB. These reports are mostly PDF files.
I need to read this BLOB field as a part of OUT PARAMETER REF CURSOR which also contains other two columns.