Forms :: Shortcut Key For Textbox Item?
Jul 11, 2013IF on button label, we use ampercent "&" to make its shortcut then is there anyway to make a shortcut for TEXT BOX ITEM ?
View 4 Replies
ADVERTISEMENT
Forms :: Create Shortcut Key In 6i?
Apr 25, 2011how can i use "Ctrl+N" key combination for new record using menu bar.
View 1 Replies View RelatedForms :: Calling Two Different LOVs At Same Textbox?
Jan 10, 2011Is it possible to populate two different LOVs on same textbox?
Textbox : ITEM_DESC
LOV1:
select desc, code from items order by 1;
LOV2:
select code, desc from items order by 1;
Forms :: How To Validate Alphanumeric And Symbol In Textbox
Nov 12, 2012I have created a form that have a button to check the character in the textbox is alphanumeric and symbol. Here attached the code, that i tried from other post.
View 5 Replies View RelatedForms :: Updating Value Of Table From Textbox Which Is On Form
Oct 30, 2013i m doin simple application, in which all data is retrieving from table in to form(all the
field are textbox and button on form) ename,dept,salary,dept_id etc.
i took one textbox field on form which is non table field
(no db field bt linked to another table..via LOV m retrieving value into this textbox which suppose dept_id ) and now after selecting one record from list box into textbox which is non table field.... after immdiately selecting i want to update one field into db field which all other form field contains...
so how to do this??which trigger i hav to use for this?
if :dept_id is not null then
begin
update dept
set loc =:emp.loc
where dept_id = :emp.dept_id;
forms_ddl('commit');
exception
when others then
null;
end;
end if;
it giving error.......if m using commit in this...i hav used post query trigger ...is dere
any other trigger hav to use
Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item
May 22, 2010I have 2 items in my form:
1) Text Item
2) Tlist
Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .
Forms :: Move Cursor To Another Item From WHEN-VALIDATE-ITEM
Apr 19, 2012I need to move to control to another item in a same block from WHEN-VALIDATE-ITEM trigger. [WITH OUT USING ANOTHER TRIGGER]
View 6 Replies View RelatedClient Tools :: How To Disable Shortcut Or Change Key Mapping
Feb 18, 2008I have a problem with getting '|' sign in TOAD Editor. It is default for Croatian keyboard layout that I get '|' sign when I press Alt_gr+W key combination.
But in Toad, when I press Alt_gr+W combination Watches dialog is opened.I want to get '|' sign in Toad Editor when I press Alt_gr+W.
Client Tools :: Shortcut To Get Select Connection Dialog Box In SQL Developer?
Jul 8, 2011Is there a shortcut to get the Select Connection Dialog box in SQL Developer?
Every time I need to execute a Query I have to use the mouse to change the Connection, if there is any Shortcut then that would be easier for me to wotk with.
Client Tools :: Create Shortcut On Desktop To Have SQLPLUS (command Line)
Sep 6, 2010The way to create a short cut on desktop to have an sql*plus (command line).
i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, username and password)
Application Express :: Fetching Values From HTML Textbox Or Any Input Type?
Jul 27, 2012I am working on APEX 4.1.1 on Linux server. I have created one application in which I have take a HTML region where i have written the following code:
<input type="text" id="APP_ITEM1" name="APP_ITEM1" />
I am able to see the text box in page, but not able to fetch the value from it.
Forms :: Update Database Item When Non-database Item Is Manually Updated?
Mar 10, 2011I am having trouble changing a non-displayed field when a displayed field is changed.
When a user wants to un-assign a territory they want to just null the ID field (non-database item). I then need to null the PIDM field(not visible, database item) for that one record.
I tried this, but I end up putting null on all the records instead of just the one record, which ends up un-assigning all the territories not just the one.
Is there a way to assign the null to the PIDM field associated to the ID field of that particular record.
Forms :: Text Item In Oracle Forms
Aug 22, 2010How to get the value of text item in Oracle forms to pass as a parameter in stored procedure.
View 4 Replies View RelatedForms :: Set Validate Item From LOV To Yes
May 29, 2011i have a table called equipment containing engine_type_id.in the equipment form that is based on the equipment table, i added a non database item called engine_type.
i added an LOV for the engine type field, so that the user can choose the engine type from the the egine types table. i made the engine type id hidden. and set the validate item from LOV to yes.on post query trigger, i selected the engine type into the nondatabase field.
the form is working properly.
when i push CTRL F11 (query) and scroll, even if i didnt change anything the form builder asks me , do u want to save changes.
Forms :: How To Get Menu Item Name
May 5, 2009I have created a Menu in forms 6i,
I want to get Menu Item Name When i pressed any menu item in runtime..
e.g, i have a menu items like,
MENU1
ITEM1
ITEM2
ITEM3
when i pressed ITEM1 then it should display ' MENU1.ITEM1 ',
how can i get this..?
REMEMBER !! I WANT TO GET MENU ITEM NAME IN RUNTIME , WHICH IS CREATED IN DESIGN TIME.
Forms :: Create More Than One LOV To Item?
Feb 19, 2011how can i give more than one lov item to an item?
View 3 Replies View RelatedForms :: Next-Item Trigger
Aug 16, 2013I have a multi row form (Order Entry form in E Business Suite). When I enter data in a row and error down the validate-item trigger fires and runs some code to check for duplicates, etc and after the cursor should go down to the next row. It goes back to the original row.
View 4 Replies View RelatedForms :: Go-item Not Working?
Feb 1, 2012I hab a button:
flag:=show_lov('lov16');
if :block.cliente_no is not null then
go_block('clientes');
execute_query;
go_item('block.codigo');
end if;
it calls a LOV and return a value to :block.cliente_no, then execute a query in block clientes, but cursor doesn`t goes to block.codigo it remains in the button ! Why doesn`t works ? Note: if I insert a message before line go_item('block.codigo'); cursor goes to 'block.codigo' (message('hallo');
SQL & PL/SQL :: How To Display Missing Item Names For Each Item Code
Feb 16, 2010I have a table with the following data.
item_code item_name
101 Pen
101 Pencil
101 Scale
102 Pen
[Code]...
My aim is to display the missing itemnames for each itemcode.
For each ITEM_CODE there should be four items i.e Pen,Pencil,Scale and Marker If any itemcode missed any of the itemnames those records should display in the output.
So the output should be like this
101 Marker Because the item Marker is missed.
102 Pencil Because the items Pencil and Marker are missed.
102 Marker Because the items Pencil and Marker are missed.
For itemcode 103 no records should be displayed because it having all four itemnames.
Forms :: How To Validate List Item
Nov 22, 2010I am working on form 6i..
I have developed a form with some text items,a list item and a image item...
list item......account_list(values....company,individual)
text_item..... company_name..
text_item.....image_path...
i have attached a pop up menu to image item... Add image and upload image...
When i click on 'Add image' the image path is getting enabled.. it is fine but when i am changing the account_list i need enable and disable the 'Company_name' text item... How can i achieve this??
I have tried it in when-validate-trigger on account_list...
if account_list=individual then
set_item_property('company_name',enabled,property_false);
else
set_item_property('company_name',enabled,property_true);
end if;
But no use of this....
how can i achieve it??
Forms :: Verification Of Item Text?
Mar 19, 2013I want to make a verification of an item text ,the user must enter a number of length 4. So I created a text item :number(4). and in when-validate-item trigger of this item ,I put this
if length(:block.empno) != 4 then
message('this item must containonly 4 digit');
end if;
=> the problem, when the user entered "0123" ,it should be acceptable !! but this is not the case ...
Forms :: Post_change Trigger On Item?
Jul 11, 2011 I am asked to change an existing field (Category_Desc) from a data block (applications) from a current form with a different field (Facility) from another table (Places) that is not used in the current data blocks. How do i do that and how should i populate the data... The common string between the table used in the form (applications) and the non used table (Places) is the ID No.
make this change and also with a possible trigger to generate the data....
Forms :: How To Set Text Item Transparent In 6i
Dec 21, 2011I am having Forms with background image on the canvas. now my problem is, how can i set a text item to be transparent so that the background image can be seen as clear as when there is no text item on it.
View 6 Replies View RelatedForms :: Make Cursor At The Item
Jan 25, 2013I have a button "clear" , I want when the button is clicked the items will be cleared and the cursor is at the first item, here is the
:emp.id:=null;
:emp.ename:=null;
:emp.sal:=null;
go_item('emp.id');
=>but the problem that the item changes color, but the cursor remains at the button "clear"
NOTE:
I used the "when-new-item-instance" trigger to change the color of text items
Forms :: Dynamic List Item
Sep 7, 2011how to create dynamic list item ????
View 5 Replies View RelatedForms :: No Data In List Item?
Mar 1, 2011I am populating the list item from predefined record group. the form is running fine but it didnt show the data present in the record group. I have placed the following code in Pre-Form trigger.
declare
list_id item;
rg_id recordgroup;
begin
rg_id := find_group('RECORD_GROUP9');
list_id := find_item('block2.list4');
clear_list(list_id);
populate_list(list_id, rg_id);
end;
Forms :: Trigger When Validate Item
Dec 18, 2012i need to pop up an alert using a trigger to test the data type of a field per example if the input is not a number an alert will popup "Please insert a number"
View 5 Replies View RelatedForms :: Populating A Value For List Item
May 20, 2010I created one list item.which is populating values from list item query dynamically.If i select a particular value from list it will create new record.for the new record line i want to display list item as 'complete' (i.e not exists in the list).At this time i don't want the list also.How can i assign value to the list item in this scenario?
View 9 Replies View RelatedForms :: Pre-text-item Trigger?
Nov 17, 2008In my form, for an item there is code for pre-text-item trigger. In query mode when i go to next record, previous record etc, whether this trigger gets fired? In other forms it is getting executed. Only in this form it is not getting executed. What should be reason for not executing this pre-text-item? Only this item is enabled and cursor is there.
View 9 Replies View RelatedForms :: Key Press In Text Item
Oct 9, 2010A form with two text fields text1 and text2. Now i want to enter text value in the text1 field and subsequently this value entered into text2. i.e if i want to press x in text1 it also in the text2. if i want to press y in text1 it also in the text2. and so on without using enter key.
View 3 Replies View Related