Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: go_item in enter-query mode

Re: go_item in enter-query mode

From: Gerd Volberg <Volberg_at_Opitz-Partner.DE>
Date: Mon, 08 Nov 1999 16:19:19 +0100
Message-ID: <3826E9F7.BA6AF5EB@Opitz-Partner.DE>


Hi Wim,

the problem is, that with each enter-query-mode oracle creates an internal new "shell". In this shell first fires a when-new-record-instance. In this trigger you have to include your source!

Sourcecode:

BEGIN
  ... do something...
  ... write your actual item into a global-variable...   do_key ('enter-query');

      NEW-SHELL       END OF NEW-SHELL
  ... erase your global-variable ...
  ... next step in your outer-block...
END; In the NEW-SHELL you see a WHEN-NEW-RECORD-INSTANCE firing. You have to write a little code for that trigger :

BEGIN
  IF :system.mode = 'ENTER-QUERY' THEN

    ...your code...
    ...read your item from the global-variable and do a go_item () ! ...
    ...your code...

  END IF;
END; Have a nice day
  Gerd Volberg
  Opitz&Partner GmbH

Wim Valgaeren wrote:

> The problem is that he doesn't do the go_item before the query is executed.
> And I want him to do the go_item when going into enter-query mode.
>
> Anyway, thanks for your reply.
>
> Wim Valgaeren
>
> David Blethen <dblethen_at_bhe.com> wrote in message
> news:3826d411_1_at_news.cybertours.com...
> > Do you know that enter-query isn't changing the :system.trigger_item ?
> > try:
> > variable := :system.trigger_item;
> > do_key('enter-query');
> > go_item(:system.trigger_item);
> >
> > Wim Valgaeren <valgaeren_at_softhome.net> wrote in message
> > news:8067p8$llf$1_at_naxos.belnet.be...
> > > I have a form-level when-mouse-dubbleclick trigger which has
> > >
> > > do_key('enter-query');
> > > go_item(:system.trigger_item);
> > >
> > > in it.
> > >
> > > When I dubbleclick on an item the record goes into enter-query mode, but
> > the
> > > cursor jumps to the first item in the record.
> > > How can I make the cursor jump to the item where I have clicked on?
> > >
> > > Thanks,
> > >
> > > Wim Valgaeren
> > >
> > >
> >
> >
Received on Mon Nov 08 1999 - 09:19:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US