Oracle Forms 4.5 and KEY-EXIT Trigger

[Richard Hanak]

Does anyone out there have a bullet-proof, single, generic routine to enhance
the KEY-EXIT trigger in Forms 4.5?

I am at a loss to code a single routine to handle all the things that can call
the KEY-EXIT trigger to either cancel a query or exit the form. Currently, I
have identified the following items in a form that can call the
KEY-EXIT trigger (this list assumes a toolbar exists with buttons for cancel
query and exit form AND a menu exists with menu items for cancel query and
exit form):

These items should EXIT the form:
-----------------------------------------------------
Exit Form Button
Exit Form Menu Item
CTRL-Q (when not in ENTER-QUERY Mode)
Double click on Windows Control Box (upper left)
ALT-F4

These items should CANCEL QUERY Mode:
-----------------------------------------------------
Cancel Query Button
Cancel Query Menu Item
CTRL-Q (When in ENTER-QUERY Mode)

I cannot create a single KEY-EXIT trigger/PL-SQL Program unit to determine
which above item called the KEY-EXIT trigger and therefore what function
should be executed (exit form or cancel query).

Can *anyone* out there help?

Thanks in advance,

Richard Hanak

>====================================================<
> Richard Hanak <
> Analyst III <
> Alberta Blue Cross Phone: (403) 498-8273 <
> 10009 - 108 Street Fax : (403) 498-8384 <
> Edmonton, AB T5J 3C5 <
> CANADA <
> eMail: rha...@compusmart.ab.ca <
>====================================================<

[Donald G. Bowles]

The KEY-EXIT trigger will not fire when canceling a query. When a form
is in the query mode, a call to the forms built in exit_form is made to
cancel the query. This is not to be confused with KEY-EXIT trigger.

Also note, if you are trying to have the same code called to exit the
form, put the code in the KEY-EXIT trigger. Then on your menu or button
issue a DO-KEY(exit_form). This will insure the same code being
executed whether your end user selects the button, menu or key. As for
the window closed issued, my best guess is again issue a
DO-KEY(exit_form) on the WHEN-WINDOW-CLOSED trigger.

Hope this was some help.

Don