I 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 RepliesI want to change the current visual attribute color of my form at the application level, reason being i don't want to generate all the forms again from scratch.I know that we can change this using visual attributes but is there a way to change this through some form setting?(Oracle 10g)
View 3 Replies View Relatedhow to get visual attribute name into a variable ??I have used the below code....
s_v:=get_item_property('slot1',visual_attribute);
but i am unable to get the name of the visual_attribute..
way to set the properties of a visual attribute group during runtime? During our forms 6 to 10 conversion we missed that our visual attributes for mandatory and not-manadatory items were different, so we have font size 8 and 9 in our system now, does not look very nice.
View 1 Replies View RelatedI have a database block that refreshes using a timer. In short, I list all open work pieces for a certain garage, displaying route, run, on_time, of_time, location grouped by garage, on_time, off_time
I need to highlight every garage with a different color. I am highlighting the on_time every time the garage changes.
The problem is, every time I move down the records, instead of keeping the previous garage color, and highlight the new garage on_time with a new color, the whole on_time column will be set to the current garage color.
I need to break down the block by color so the user can distinguish between the different garages, and the start and end time. Here is my code, I am putting it in when_new_record_instance of the work_block:
IF :work_bLock.current_garage = 9006 THEN
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r191g223b191');
ELSIF :work_bLock.current_garage = 9002 THEN
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r255g228b196');
ELSE
Set_Item_Property('work_block.on_time', BACKGROUND_COLOR, 'r255g250b250');
END IF;
I need the block to be 3 or more different colors depending on the garage.
I am trying to disable mouse navigation on data block or text item,. What i want is to my text items in specified block be keyboard navigable only.
The problem is that i don't have that option on text_items or data block (my conclusion: probably because it is not possible to change mouse navigate option for text item or data block).
I have also tried in WHEN-NEW-BLOCK-INSTANCE trigger
set_item_property('block.item', mouse_navigate, property_false)
and
set_block_property('block', mouse_navigate, property_false)
and of course it did not work.
We are facing below issue in Oracle forms 10g( Rel 10.1.2.0.2) with Windows XP professional.Application server J2EE 10.1.2.0.2).
We have a multirecords block. After navigating to last record by clicking mouse in scroll bar and change values in a column by clicking mouse in column to change, cursor control is moving to some other record(where cursor is located previously) and current changed value it is showing as not fully validated.
Eg: We have columns like below in multirecords block
Security Price Date Price
--------------- ------ ----
1 1/1/2011 12.00
2 1/1/2011 16.00
3 1/1/2011 18.00
4 1/1/2011 19.00 (Last Record)
If am changing last records price to 20 then press tab key, cursor will be moved to second record and cursor will be highlighted in security 2. column price where we changed to 20 also not validated to show as 20.00 with 2 decimal format mask.Along with this we are getting below error message ' FRM-41008 - Undefined function key, press Ctrl + F1 for list of valid keys.After changing the price we are pressing the tab key only.
This occurs randomnly and when we querying more than 2000 records with multiple times.
I got a required to show LOV or list ... based on some value in other column. suppose in column A has value is A1 then column B should show A11, A12 , A13 and if Column A has value C then cloumn B should show C11, C12 ... etc//
View 2 Replies View RelatedI have text in a display item on my Oracle Form. When my user hovers over the text with my mouse I want it to show my user that the text is active. The text may change color(no tool tip).
Is this possible?
Environment: Client / Server
I have uploaded some tables from MS Access to Oracle and in the process, some Number fields have been converted to Text. This means that any Queries where there are calculations with those fields (which have been converted to text) don't work properly anymore.
I would like to change the field type from text to number (with cmd and sqlplus) as that's the only way I can access the oracle backend.
I am not sure what commands to use to change this.
Also, if I change the data type from text to number, is it likely I will lose some data?
And how do I backup the table before I do this?
I had created a form, in that i having two fields for username and password.
The problem is i want to make the fields as fill must.
if the user leaving the username field without entering anything trigger must raised. Otherwise if we are entering the data it should allow him to go for the next block without any raising of triggers.
I have created a simple master/detail form which is in easy navigation for user. The form have master/detail block with tabular style showing 5 records, When user click on master record the detail will show the opposite as master record point.
See attached file.
I'm studying the guide Oracle XML DB Best practices and it is ok to add, modify or delete nodes. Also to change the value of an attribute, but I'm looking for adding an attribute.What is exactly the statement, for example to add the attribute modification_date for the root element process for a field xml_data ?
View 1 Replies View RelatedI 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 RelatedText 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
I 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.
I 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?
i 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.
I need to copy some text value in to a multi-line text item on the current cursor position.
View 8 Replies View Relatedthe code for show increasing digit 1 to 100 in a text field after pressing a button 100 times?
View 26 Replies View RelatedI 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.
why when-mouse move,up,enter,leave are not working in oracle forms 10g except when-mouse-click and when-mouse-doubleclick on any items.
what i need to do to execute this triggers..
i am migrating from forms 6i to forms 10g but i am facing a problem. when i enter to my new form and i try to navigate thru the items with my mouse the validation of the item doesn't work properly. the cursor change position but the functionality works like it is still in the first item. the validation work when you use enter or tab.the same thing when you try to fetch the LOV, the LOV of the first item is populated not where the cursor is positioned.
View 3 Replies View RelatedI am using the below code to disable forms field in fdtlblk.mdt_rqr = 'NO'
but I can go there with mouse click ( for tab and enter it is working fine ) .
but for mouse click it is not working .
if (:fdtlblk.mdt_rqr = 'NO') then
go_item('fdtlblk.section_loss');
set_item_property('FUP_RCVD_DT',enabled,property_false);
[Code]....
I created TREE object in my application main menu and I want to use it through MOUSE and KEYBOARD therefore I add WHEN-TREE-NODE-ACTIVATED trigger at my tree object
Trigger text is:
declare
htree item;
node_value VARCHAR2(100);
akt_node ftree.node;
[code]...
Problem:When I am using MOUSE and clicking on + or anyother form/report, it's opened last selected form/report or application closed but it is working fine when I am using KEYBOARD.
I want to link to blocks using description as there is no relation , for example i have two tables with one field in common called description, and i want to link this field in two tables using like operator.
create table item ( item_code varchar2(12),item_name varchar2(30));
insert into item VALUES('A','HEA160');
insert into item VALUES('B','HEA180');
create table stk (sl_item varchar2(12),sl_desc varchar2(30),sl_qty number);
insert into stk VALUES ('X','HEA160X1000',12);
insert into stk VALUES ('X','HEA160X2000',4);
insert into stk VALUES ('Y','HEA180X3000',10);
Suppose i click on item block item_desc with value on HEA160 all the items similar to that should appear in stk block like 'HEA160X1000' ,'HEA160X2000' , if i click on 'HEA180' on item then 'HEA180X3000' it should come.
I would like to know if with Oracle Forms Builder 11g, we can use mouse instead of TAB to validate record? And why Forms Builder use TAB or ENTER Key to validate record? I have a SAVE button, but i want to replace the TAB navigation validation by the mouse click. Is it possible?
View 6 Replies View RelatedI created Main Menu form and in this form I attached popup menu in picture's property problem is that when i right click on this picture then show the popup menu .I want when I click left click then it should show the popup menu.
View 2 Replies View Relatedwhat 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;
i am a Microsoft SQL Server user,and I recently thought of migrating to Oracle.So to give it I try I downloaded the following files : [URL]
But for the past two days I am heck stuck with making a Proper Installation ! I have swept the Internet and the Oracle Forums but there is not single tutorials on how to 'INSTALL' these products completely.(All tutorials are on on 10 XE and dont cover Dev Tools installation)
For eg. I installed Oracle 11 XE and ODAC 11.2 Release 5 (11.2.0.3.20) with Oracle Developer Tools for Visual Studio but still the database was not connecting.A blog suggested that I should edit and place the tnsname.ora files in the correct location then I should configure the machine.config file.But Oracle says that its universal installer automatically configures the config file.
Honestly,I love tough things but its stupid the way oracle is deploying its products. how to install and configure Oracle 11 XE with Visual Studio 2010.
dont get me wrong but this is way too outdated: [URL]