Forms :: Close A Window In Query Mode

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


ADVERTISEMENT

How To Close Window In Oracle Forms 6i

Nov 27, 2004

code for "when button pressed" trigger that will close the current window and displays another window.

View 4 Replies View Related

Forms :: Close Java Applet WebStart Window

Dec 18, 2010

I am Trying to use jnlp file to launch my form application and it looks good, all works fine , except one thing

1) When i close form application, the webstart applet window doesn't close.

View 1 Replies View Related

Reports & Discoverer :: How To Close Window Automatically Without Manual Intervention

Oct 20, 2010

I am running a report which is called for a set of employees picked up in the cursor. For each employee the report is run in a different window. However, the report runs fine and the output gets saved in the local machine but the window doesn't get closed automatically.

How to close the reports window automatically without manual intervention?

View 2 Replies View Related

Forms :: F11(Query Mode) And Execute Query In Oracle?

Jul 17, 2011

how to achieve F11(Query mode) and Execute Query in Oracle Forms?

View 1 Replies View Related

Forms :: How To Cancel Enter-Query Mode

Aug 31, 2011

When i entered for modification/deletion process initially i prefer to entry-query mode then execute the query.

Suppose when i am in entry-query mode but i want to cancel(abort) the mode ie. entry query. How to achieve this.

View 3 Replies View Related

Forms :: How To Make Query Mode Work (f11)

Apr 2, 2012

I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.

View 18 Replies View Related

Forms :: A Button Has To Be Disabled In Query Mode (F11)

Apr 3, 2012

Am developing a custom form. I have a block with 5 Items and one button(SUBMIT). When I go in query mode (F11), SUBMIT button to be disabled. How do i achieve this.

View 22 Replies View Related

Forms :: Disabling LOVs When Not In Enter Query Mode

Nov 5, 2010

I currently have a form in which a master block populates a detail block. when the master is populated the cursor automatically goes to the detail block and sets it to enter query mode (due to the face that there are multiple details but the user may only view one at a time). To select the appropriate detail the user may select the detail from a LOV which is activated by clicking a button. once the detail has been selected and the query executed there is no real need for the LOV as the user can now edit/delete the detail. Also when adding a new detail there would be no need for the LOV as the presence of it would only confuse users. So basically the only time the LOV is usefull is during query mode to query the detail the user wants to edit/delete.

View 1 Replies View Related

Forms :: How To Use When-validate-item In Enter-query Mode

Oct 14, 2012

I have to create a form and i have to use trigger when-validate-item in enter-query mode . I have read trigger when-validate-item can not use Enter Query Mode . Is there any way to do this when i enter-query?

View 5 Replies View Related

Forms :: Clear A Block For Enter Query Mode?

Jan 16, 2012

I am using Forms 6i,Oracle 10g. In a form I created, I have 3 blocks, first is a toolbar type with buttons to save, exit etc., other two are one master and detail data block.

how to get the default Oracle toolbar with the buttons, save, delete etc. I dont get in my form.

When the cursor is inside the detail block and then I click on an EnterQuery button in the first block, how do I clear the detail block, using the on btn press code.

What happens when I click the Enter Query button, is that the cursor and current block becomes the button block and when I run the command ENTER_QUERY, no use.

I need to set the block in which the cursor is to be cleared for query, whether it is master or detail, by pressing the button on the first block.

View 7 Replies View Related

Forms :: Query Mode Not Working At Once The Form Is Opened

Jul 10, 2012

At once when I open the form when I press F11 it is not entering query mode. But if I type something in the text box placed in the form then I press F11 means it is asking "Do you want save the changes you have made?" if I press yes or no, no matter it is going for query mode. How to go to query mode without typing something in it?

View 13 Replies View Related

Forms :: Enter-Query Mode - One Item In A Block Is Not Getting Cleared

May 24, 2010

I have a form in which there are three blocks A,B and C. When I press F7, the form enters Enter-Query Mode and all blocks clear except block A's one item. Say, Block A has 5 items, Item1, Item2,.. Item5. When I enter Enter-Query mode, Item2 of block A is not cleared and rest all are cleared.

View 2 Replies View Related

Forms :: Sort Data In Execute Query Mode During Runtime?

Nov 15, 2012

How can i sort data in the execute Query mode during runtime,i have a columns which has number, char and date field.

This below data is fetched in execute query from a table;
x1 x2 x3
1343 adfa 11/14/2012
1353 adfa 11/11/2012
1333 adfa 11/10/2012
1333 adfa 11/12/2012
1353 adfa 11/09/2012

now i like to sort like this below;

x1 x2 x3
1343 adfa 11/09/2012
1353 adfa 11/10/2012
1333 adfa 11/11/2012
1333 adfa 11/12/2012
1353 adfa 11/13/2012

how to do it?

View 4 Replies View Related

Forms :: Can't Navigate Out Of Current Block In Enter Query Mode

May 11, 2010

I have a form with multiple tabs, each tab showing one data block. Many of the blocks are standard in enter-query mode. I want to allow the users to navigate through the tabs while the blocks are in enter-query mode.how can i do this?

View 3 Replies View Related

Forms :: DDE Package - How To Close Excel File Without Saving Changes / Messages

Nov 19, 2009

I need to rescue some valors from Excel, and then close the excel file without saving changes and without messages.

I am using THe DDE package and when using

DDE.EXECUTE(convid, '[Save()]', 10000);

there is no problem, but the changes are saved. I have tried '[Exit()]' and '[Close()]' but always have error message ORA-106555. Is there any way of doing this without errors?

View 11 Replies View Related

Forms :: Windows Close / Click On Save Button Data Get Saved

Jun 29, 2010

i design one master detail block and one command button for saving the data....as i click on save button data get saved and after that if i want to close form then at this time it again asking me for save changes window..

View 8 Replies View Related

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

[code]......

View 14 Replies View Related

Forms :: How To Get Window Handle

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

Forms :: Call Another Canvas In Same Window?

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

Forms :: New Window Opened As Deactivated

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

Forms :: Icon In Window Title Bar?

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

Forms :: Hiding Window Failing On 6i

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

Forms :: Command To Maximize The Window

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

Forms :: Tap And Toolbar Canvas In Same Window

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

Forms :: Set Size Of Window In Browser?

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

Forms :: Get Conditional Window Appear In Form

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

Forms :: Take Pic From Cam Window And Save It To Field In Database

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

Forms :: Maximize Window On Secondary Screen

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

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 View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved