Re: HelP, PLEASE ! Forms 3.0.16 (Dos)

x93aroor_at_wmich.edu wrote:
: ..... <deleted> ....
: My problem is this: If I try to enter a query (by pressing enter query )
: while
: my cursor is in this field, it instead fires my (above example) trigger.
: ..... <deleted> ....
:

There are 2 ways to do it :
(1) My preferred method is as follow:

    "on-validate-field" checks if the field is null before validating     the entry against the table:

           if <field> is not null then
              ..... <your validation> ....
           end if;

(2) If the above is not possible, either use a hidden field or a global

    variable as a flag to indicate that you are in "enter query" mode.     You'll need to set the flag at the beginning of "key-entqry" trigger     and check it before validation in "on-validate-field" trigger.     Remember to reset the flag after the "enter_query" package procedure     that you have in "key-entqry" trigger. (Yep, you'll have to override     ORACLE's default).

Good luck

Kim Ng
Paradigm Computer Consulting, Inc.
20611 E. Bothell Everett Hwy SE
Bothell, WA 98012
e-mail: kimmng_at_eskimo.com Received on Sat Dec 31 1994 - 07:22:57 CET