Forms :: Navigation Triggers In WHEN-WINDOW-ACTIVATED?
Mar 22, 2011
A requisition application shows the latest requisition details in the homepage and allow the users to go particular requisitions (extract) details from a button (CALL_FORM), also they can modify the records in that form.
I want to give an EXECUTE_QUERY (WHEN-WINDOW-ACTIVATED) when im returning to the home page and the cursor should return to the last row where i was.
do this from navigation triggers (with out writing a select statement in when-window-activated).
View 1 Replies
ADVERTISEMENT
Jan 9, 2012
'm using go_item to open the canvas but the cursor doesnt want to focus on the item. I have to mouse click the item before I can enter any data or tab through it.
View 16 Replies
View Related
Feb 8, 2011
I have 2 non data base blocks, these 2 blocks act like master details but there is no relation. In header block i have 2 fields called "Product name" and "Product Type"
in detail block having 2 tab pages one having multi record(20 item number and name displayed on it) another one having single record but it has around 20 image items displayed on it.
My requirement is once i enter the product name and then if i press either "key tab" or "Key Enter" or "Mouse Move" from product name field
into product type field then detail record should be populated automatically without using go_block and go_item.
View 4 Replies
View Related
May 6, 2013
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 Related
May 23, 2011
what is the basic workaround to provide to switch from one form to another form via custom-menu at runtime?
I attached a menu-item to every of my forms and I can call them seperately from the forms builder. But I am not able to switch between the forms then. If I am clicking on a menu-item, I get frm-40010.
P.S. I'd prefer to close the current form, if the new form has been opened. Do I have to control this seperately or is the closing of the last form default?
View 3 Replies
View Related
Nov 8, 2011
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.
View 1 Replies
View Related
Feb 10, 2011
I have developed customer entry form, its working fine. I have 2 display items on form. One is country name & other is region, these are fetched based on country id LOV.
Now I want to display country name & region at time of navigation. I have written following code on WHEN_NEW_RECORD_INSTANCE of block.
******
DECLARE
CCNTRY_ID VARCHAR2(2);
CCNTRY_NAM VARCHAR2(25);
CREGION VARCHAR2(11);
begin
select cntry_nam,region into ccntry_nam,cregion from cntry where cntry_id=ccntry_id;
exception
when no_data_found then
message('NO DATA FOUND');
end;
**********
I always get message not data found on navigation. Problem is only with the display item other, values of database columns are being shown.
View 3 Replies
View Related
Jul 15, 2011
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.
View 5 Replies
View Related
Aug 5, 2012
I have a system that has issues with sending some emails.
When the email sending process is activated the pages just hang.
Are there any logs or anything like that anywhere that i could look at to try and make sense of it.
View 1 Replies
View Related
Feb 9, 2010
The following code works fine in the form 6i, but in the same form 10g I get map_handle='0' and win_handle='0' instead of certain value as in 6i.
map_handle:=get_item_property('MAP.MAP_ITEM',WINDOW_HANDLE);
win_handle:=get_window_property('CG$WINDOW_1',WINDOW_HANDLE);
MAP.MAP_ITEM has Chart Item type.
View 3 Replies
View Related
Sep 5, 2010
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..
View 3 Replies
View Related
Dec 12, 2012
can change the order of triggers in forms 6i . that means firing in form level?
View 4 Replies
View Related
Oct 24, 2013
I am working on a form, whose one block is query_find, so on clicking find button it will open another block.the find block contain 4 column and second block contain around 10 column.but the column present in find block are associated to standard tables and the column present in block-2 are from custom tables.there is a query which link those column.
I am not sure where to use that query, so that it will take input from the find block and then populate the result into the block-2.
View 13 Replies
View Related
Jan 18, 2006
Suppose if I have defined two triggers Key-next and When-validate-item on the same item.
If my key-next is going to fire first and When-validate-item laterhow can the validation happen if I write a code like go_item('XXXX') in my Key-next.Does it mean that if u write a code in key-next to jump to some other item, no validation takes pLace?
View 14 Replies
View Related
Jan 24, 2012
May i know the triggers in forms 6i, which is applicable to all items,blocks and form.
View 9 Replies
View Related
Nov 27, 2004
code for "when button pressed" trigger that will close the current window and displays another window.
View 4 Replies
View Related
Feb 22, 2013
I want to call another canvas in same window.using this code /it not work show_view('canvasname');
View 1 Replies
View Related
Jan 15, 2011
i want to open a new window from my form. everything going well but when a new window opened. the control remains on previous form. and the new window is also inactive. i tried go_item with the item belongs to the new canvas but in vain.
View 14 Replies
View Related
Jul 23, 2010
I am using Developer 6i and i want to know how to replace the default icon in form window title bar with company's logo.
View 1 Replies
View Related
Apr 24, 2010
I have to create a new window in a newly developed forms 6i (in Oracle e Business Suite 11i).
This new window is to duplicate the Oracle standard alert systems. I have to create a new one to match the style classes of the other windows in the developed forms. Actually, I did not manage to change the oracle alert I used first, to match fonts, colour and sizes defined in the customised class. Thus, I decided to create a new window and canvas.
It has to display a confirmation message with 2 buttons: OK, Cancel. This window contains a canvas displaying a confirmation message, and 2 buttons : Ok, Cancel attached to my data-block. I manage to show this window, with a show_window command, called from a button on the previous window's canvas.
I do not manage to hide this new window, and to come back to the previous one, when I click on Cancel button. The window does not hide.
View 8 Replies
View Related
Mar 9, 2010
Some of the items are not getting displayed properly in my form when i run.I want all of them to appear on form. Can i maximize when i open.If so whats the command.
View 5 Replies
View Related
Feb 21, 2010
I use forms10g in windows xp, i create a tap and toolbar canvases in content canvas but at runtime i can see only toolbar canvas.
View 1 Replies
View Related
Jan 22, 2013
how i can set the size of runtime window in My browser? I have a larg form ( 800 X 600 )
View 1 Replies
View Related
Jun 2, 2011
I want to achieve functionality like below:
Let's say there are two almost identical window and some specific functions associated: W1 and W2.
Depending upon the login profile into the application only one window and associated functions will be appeared. This time the other window will be disabled.
View 3 Replies
View Related
Apr 10, 2010
How do I close a window in query mode?My form has a button "Populate from Charge Master" which opens a window containing a List Item (Department Names) and 2 buttons,
1. "Select the Dept" and
2. "Cancel"
The WHEN-BUTTON-PRESSED trigger code for "Populate from Charge Master" button is as follows:
begin
SHOW_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
go_block('bl_med_dep');
enter_query;
end;
Code for "Select" button in the window is:
populate_from_charge_master(:bl_med_dep.med_dep_code,:bl_med_charge_party.charge_party_no);
execute_query;
COMMIT;
HIDE_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
GO_BLOCK('BL_MED_CHARGE_PARTY');
EXECUTE_QUERY;
Code for "Cancel" button in the window is:
BEGIN
hide_window('WINDOW_POP_FROM_CHARGE_MASTER');
show_window('WINDOW1');
GO_BLOCK('BL_CHARGE_COMPANY');
END;
Here WINDOW1 is the main window and WINDOW_POP_FROM_CHARGE_MASTER is the window which must be closed when "Cancel" button is pressed.
When I remove "enter_query" statement in "populate from charge master" trigger code, I am not able to select any of the departments from the list. and If I have that statement, I am not able to hide/close the window.
View 5 Replies
View Related
Dec 21, 2012
I have a requirement to take pic from a cam window and save it to forms field in database.
View 2 Replies
View Related
Aug 20, 2012
I've already check on internet and the forum if there is a way to maximize a window on the secondary monitor instead of the main one. There is a parameter to make that? or Oracle forms maximize the windows only on the main screen?
View 1 Replies
View Related
Jul 7, 2012
i want to open dialog window using oracle forms 10g on button click event.
View 3 Replies
View Related
Aug 26, 2011
I 've noticed transactional triggers, as a value for Query data block property, How can i use it, and is it really 's mode advantages than using from clause and procedure based with DMLs on non-based items?
View 3 Replies
View Related
Nov 29, 2010
is there a way to set the default sizes for the canvas, object navigator and properties window in forms designer so that they don't maximise when opening them. i tried to set them in the caupref and cagpref files to no avail.
View 4 Replies
View Related
