go_item in enter-query mode

[Wim Valgaeren]

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

[David Blethen]

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 <valg...@softhome.net> wrote in message
news:8067p8$llf$1...@naxos.belnet.be...

[Wim Valgaeren]

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 <dble...@bhe.com> wrote in message
news:3826d...@news.cybertours.com...

[Gerd Volberg]

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

[Steve Cosner]

Wim Valgaeren wrote:
>
> 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?

I think the Enter_Query command is as far as the trigger will go because
at that point, control is transferred from the running pl/sql trigger to
the user. But the go_item may execute after the user does the Execute
Query--I am not sure.

Try starting a timer before you Enter_Query, and do the go_item in the
When-Timer-Expired trigger.

Steve Cosner

[Wim Valgaeren]

Thanks,

You helped me alot.

Regards,
Wim Valgaeren

[Brian Neary]

Put the go_item(:system.trigger_item) in the form level KEY-ENTQRY trigger.

Wim Valgaeren wrote in message <8067p8$llf$1...@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
>
>

[Brian Neary]