Replication :: Oracle Forms 10g Access Key Property For Button
Jan 22, 2013
just i want to ask about access key property for button..i'm using oracle forms 10g ,
suppose that i have 3 buttons in a module like the following:
1- buttonOne --access key property for this button is "1"
2- buttonTwo --access key property for this button is "2"
3- buttonThree --access key property for this button is "3"
when run this module then the user press "1" the trigger when-button-pressed not fire until he press Alt+1...how the user can press the "1" only to fire the trigger when-button-pressed? just like form 6i?
View 6 Replies
ADVERTISEMENT
Apr 3, 2013
I want to show or hide some items on my form by using the SET_ITEM_PROPERTY to enable or disable VISIBLE. i have a button NEW, my need is when i click on this NEW button it should be hide and some other items should be show. but when i click on this its only showing other items but not hiding the NEW button. my NEW button is like this:
[b]set_item_property('select.new',visible,property_false);
set_item_property('select.new',enabled,property_false);
set_item_property('select.new',navigable,property_false);[/b]
------------------------------------------------------------------
set_item_property('control.section',visible,property_true);
set_item_property('control.section',enabled,property_true);
set_item_property('control.section',navigable,property_true);
set_item_property('control.year',visible,property_true);
set_item_property('control.year',enabled,property_true);
set_item_property('control.year',navigable,property_true);
View 3 Replies
View Related
Mar 30, 2011
i am building a system and have created some forms, but when i view them on 10g server online i only want each form to be accessed via a button of which i have placed code to go to that block. not be able to use the arrows to skip.
View 1 Replies
View Related
Jun 27, 2011
i am running oracle 10g developer release2. i want to set item property false/true in response to a specific action, like disabling text item when check box or radio button pressed.
View 1 Replies
View Related
Aug 28, 2012
this from has multirecords and multiblocks for every date it shows employees' attendance record, there is a button that should disable selected records for that specific date
**part from the code**
LOOP
if :ATTENDANCE.SIGGNED = 'Y' AND GET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',STATUS) = 'CHANGED' THEN
:ATTENDANCE.LAST_UPDATED_BY:=fnd_global.user_id;
:ATTENDANCE.LAST_UPDATE_DATE:=sysdate;
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',ENABLED,PROPERTY_FALSE);
[Code]...
what happen that it is confirming that selected records are disabled AND it is NOT!!
**i can still change the records if i want **
but if I changed the date and go back "the date which i disabled its records" (reload that data) then it will be disabled
finding a way so it will be disabled immediately so i don't need to change dates to be disabled
**maybe if there is a code that will refresh records ?!
View 4 Replies
View Related
Jul 19, 2013
What is the uses of "Validate From List" Property(Yes/No) in LOV's Properties.
View 3 Replies
View Related
May 1, 2010
I'm new with javabean I find this website URL.....
most of this examples use this built-in Set_Custom_Property..i need you to provide with syntax and the full list of property in this built-in
all or most of the examples there is (1) in second parameter what is this (1)
View 9 Replies
View Related
Jun 6, 2010
The code on menu item is UnVisible_Menuitem('ITEM193');
Menu procedure is
PROCEDURE UnVisible_Menuitem( menuitem_name VARCHAR2) IS
mi_id MenuItem;
ALT NUMBER;
BEGIN
mi_id := Find_Menu_Item( menuitem_name );
[code]...
i try it for the both visible and non-visible items but it dosnt work.
View 1 Replies
View Related
Nov 28, 2011
I am using Forms 6i in Oracle Applications, In the button click event i used set_canvas_proeprty() twice. First time it executes these two statements, second time it does not. If i use any message() statement before these two statements, it executes.
Do we have wait() statement in Forms ?in apps we have app_item_property.set_property(), can we use same command to set canvas property also.
View 1 Replies
View Related
Aug 1, 2012
My requirement is I have placed a check Box in the Detailed Block and i have assigned values for the check box as
Checked - R
Unchecked - P
Initial Value - R
by default the check box would be displayed as Checked while inserting the values in to table the value of check box is not getting inserted but when the check box is unchecked the the value is getting inserted as P when the submit button is pressed.
View 11 Replies
View Related
Jun 27, 2010
I have a form which contains some block (each block with some text item, two radio groups and a list item). I want to enable/disable and set visible property as true/false for first to last items of each block conditionally. I can do that for all items but radio buttons.
Because to set item or radio button property I need to pass that items ID or Name as parameter. I can get items name/type using get_block_property and next item of that item using get_item_property but unable to get radio button ID/Name using get_radio_button_property or any other built in. To execute get_radio_button_property or set_radio_button_property I need to pass radio button ID/Name. So, how I track radio button id or name in oracle forms? Is it limitations of Oracle forms?
View 8 Replies
View Related
May 9, 2012
Is it possible to change the item_type property of an item at runtime.
I have one text item and i need to lock(Read only) that item. I hope we can change the ENABLED property or by changing the ITEM_TYPE as DISPLAY_ITEM.
How to change the Item_Type to DISPLAY_ITEM from TEXT_ITEM at run time or else is there any other way except ENABLED property to male the field as READONLY.
View 2 Replies
View Related
Jan 20, 2011
i've created an alert with 2 buttons and the code for cancel button is as follows:
...
if alert_id = alert_button2
then
raise form_trigger_failure;
end if;
...
this code is in a pll and when called from a form it displays a non oracle exception message. How to do nothing when the user presses cancel on alert pop-up? apart from using null instead of raising the above exception?
View 5 Replies
View Related
Mar 20, 2011
Can i change the property of item dynamically in pl sql coding. Actually i want that whenever the user press some button then that field(textbox) become non-database item of the database block. put some value in it and press another button to restore its property like before.
View 10 Replies
View Related
Jun 10, 2013
frm-41375: cannot set queryable property of calculated item :emp.sumsal.
View 8 Replies
View Related
May 31, 2010
Our application is using GET_APPLICATION_PROPERTY to retrieve user name, password and connect string. Since we have started using Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production the problem started with password case sensitivity. The function returns uppercase password whereas if the user has lower or mix case password they mismatch.
View 6 Replies
View Related
Mar 19, 2010
I would like to create a browser button which enables to browse a tree directory and to select a file. how can i do it?
View 1 Replies
View Related
Feb 22, 2012
Actually am trying to replicate two db servers from one in hong kong and another in china. when am trying to establish the replication, am getting error 'ORA-04052: error occurred when looking up remote object' like this...
but the same way i have tried in my local network, it is working fine.i have tried schema replication through enterprise manager grid control..
View 6 Replies
View Related
Apr 4, 2011
I want to change Database Data Block Property at runtime.
View 4 Replies
View Related
Apr 1, 2010
what are the recommended network requirements for implementing Oracle Multi Master replication.
View 1 Replies
View Related
Jun 2, 2010
when i create db link then it show below:
SQL> conn sys as sysdba
Enter password: ********
Connected.
SQL> show user
USER is "SYS"
SQL> create database LINK orafaccess using 'ORAFACCESS';
Database link created.
SQL> desc emp@orafaccess
ERROR:
ORA-02085: database link ORAFACCESS.APEX.COM connects to HO.WORLD
SQL>
View 10 Replies
View Related
Feb 26, 2013
Is there a way to apply changes to a data field on oracle forms for specific users?
For example, I have an oracle form that applies the below masking code for a certain field called CUSTOMER_ID
IF :SYSTEM.BLOCK_STATUS = 'QUERY' THEN
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_TRUE);
ELSE
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_FALSE);
END IF;
But I only want this masking to be applicable to CERTAIN users. For example, the psuedo code would be like
IF :SYSTEM.BLOCK_STATUS = 'QUERY' and USERS_LIST = 'SUPERVISORS' THEN
SET_ITEM_PROPERTY('CUSTOMER_ID',CONCEAL_DATA,PROPERTY_TRUE);
Note that this users_list is a group of oracle database users, so I am a member of this group. Also note that this form is applied via the web via the application server.
View 1 Replies
View Related
Feb 21, 2012
I have one PDA device. I need to run a Oracle form developed in Oracle forms 6i on this PDA by connecting it to the Oracle 10G database running on Linux Server.
I need to know is there any Oracle client for windows 6.0 OS. if yes then how can i install it on PDA and access the Oracle database through forms.
View 1 Replies
View Related
Feb 18, 2013
I 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 Related
Oct 13, 2011
i have a block of multiple records where the user can edit the shipment totals of products being sent to branches.
some branches can't receive certain products and usually we just default the shipment value to zero but the user can still edit that value.
What i want to do is iterate through that block and check the branch and product and set the update property to false for only that record. is that possible.
View 1 Replies
View Related
Sep 27, 2013
I have a form developed using Oracle 10g Forms Builder. It is deployed on server. I need to track who is remotely accessing the desktop and running this form. How can we track this. Are there any webutil commands to trace the application used to access the desktop? What is the work around for this?
View 2 Replies
View Related
Dec 19, 2011
I want to run a report developed by crystal reports by click on a button in oracle developer 6i.
Is it possible. If yes then how can i do this.
View 8 Replies
View Related
Sep 25, 2013
how to set connection property "oracle.jdbc.thinLogonCapability"
View 3 Replies
View Related
Sep 8, 2011
i have a form having 4 database data blocks and one non database data block(for Push Buttons like SAVE,CLEAR,EXIT..).
In the control Block i have 5 push buttons out of which one is used to Save the entries and one to clear the form. In the coding of SAVE button after writing "COMMIT_FORM;" i want to disable all other Data block on my form excluding the one containing Push buttons so that the data entered by end user stay appearing on the form till he Clears the form.
Now the problem is that when i set enabled property of one particular text_item to false , the form if closing down along with the application, it is totally disappearing from screen.This is happening for one particular text item.
what could be the possible reason for this and what needs to be done to overcome this problem.
View 5 Replies
View Related
Sep 17, 2008
I need to do a Oracle replication between databases. One resides on Oracle 8i which needs to be replicated to a database on Oracle 10G.
Is oracle replication supported between dissimilar versions of Oracle?
View 3 Replies
View Related
