Re: Method to disable key trigger (Elegant one)

In article <kenho.30.2E645E27_at_hk.super.net>, kenho_at_hk.super.net (Kenneth Ho) wrote:

> In article <340chu$k4p_at_search01.news.aol.com> jamesf5088_at_aol.com
 (JamesF5088) writes:
>
> >By defining a KEY-OTHERS trigger any key trigger NOT defined will execute
> >this trigger.
>
> So what you mean is I need to define a KEY-OTHERS trigger on EVERY
 block in a
> form?

I think no, since you can control the scope of the trigger. So if you define a KEY-OTHERS trigger in the form level it will overwrite the outcoming of a KEY trigger not defined in any level. My understanding is the following:

If one presses a key, Oracle will perform the following tasks:

Is the key defined in the field level?

      |                |
     NO               YES ---- execute this field level key trigger and stop.
      |
Is the key defined in the block level?
      |                |
     NO               YES ---- execute this block level key trigger and stop.
      |
Is the key defined in the form level?
      |                |
     NO               YES ---- execute this form level key trigger and stop.
      |

Hope this helps
LM

>
> Kenneth Ho
> Programmer
> Hospitality Data Resources Ltd., H.K.
 

-- 
Leo Mannhart
Planning Office
University of Zurich           phone: ++41 1 257 23 34
Kuenstlergasse 15                fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland    eMail: mannhart_at_zuv.unizh.ch