Oracle Forms (MOSC)

MOSC Banner

Cancel Query issue

edited Apr 22, 2010 2:26AM in Oracle Forms (MOSC) 2 commentsAnswered
We are using Forms 6i and having an issue cancelling a query from the File menu.  When we go to File-Query-Cancel, it does nothing.  I have read a few things on Metalink that state to make some changes to the Key-exit trigger to accomplish this.  I have the following code in my key-exit trigger, however, it still doesn't work.  I am able to execute the query from the File-Query-Execute selection.  Any ideas?


IF :System.Mode = 'ENTER-QUERY'
    THEN 
       :System.Message_Level := 10;
       /* Cancel Query */
       Exit_Form;
    END IF;
    Exit_Form;

Thanks.

Gayle

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center