Re: which trigger to catch the event of LOV?

If I understood you right, this might work.

1. Make your LOV return the value to a global variable (eg. global.lov_empno)
2. In the KEY-LISTVAL trigger on the empno item, write this code

  declare
    dummy boolean;
  begin
    dummy := show_lov('your_lov');
    execute_query;
  end;

3. In the PRE-QUERY trigger on the block, check if the global variable has a value   

  if :global.lov_empno is not null then
    :emp_blk.empno := :global.lov_empno;     :global.lov_empno := null;
  end if;

Hope this helps,
Ole Bredesen-Vestby

On Wed, 28 Apr 1999 23:12:05 GMT, celia_xi_at_my-dejanews.com wrote:

>Hi, all.
>
>There is a LOV connected to empno item in emp_blk block. The problem is that
>once I select a value from LOV, and then press 'ok' on the LOV, at that time,
>I would like to execute query ( automatically, not press QUERY - EXECUTE ),
>all values ( ename, job, sal ) will be shown on the forms immediately. Which
>trigger can do this job? Is it possible? And Execute_Query is a restricted
>procedure.
>
>Any reply will be greatly appreciated.
>
>Mike
>fding_at_idirect.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Apr 29 1999 - 19:24:41 CEST