Re: Forms - How to navigate to the detail block after excecute_query

Hi Deborah,

The POST_QUERY trigger executes once for each row retrieved by the query, so you can see that a GO_BLOCK in its mids wouldn't be able to work.

What you can do is to use KEY-EXEQRY on the first block. In this trigger put an EXECUTE_QUERY; followed by a GO_BLOCK(block_name) followed by EXECUTE_QUERY. In this way when the operator presses execute_query the query execution and the navigation etc is automatic.

hope this helps,

Rod Corderey

Lane Associates
Lane_Associates_at_Compuserve.com
http://www.Lane-Associates.com

Deborah Kalantari wrote:
>
> Hope someone out there can help...
>
> I'm working on a Master/Detail form that is query only. This is a
> character based form and I cannot incorporate the use buttons on the
> form. It has to be all keyboard driven.
>
> The user enters in a purchase order number (in a master block item)and
> then they EXECUTE_QUERY. At that point I need to navigate
> programatically to the detail block (this is a requirement - so the user
> can down arrow to scroll through the detail records). I tried GO_BLOCK
> in a POST-QUERY trigger. But this doesn't work since GO_BLOCK is a
> restricted built in and restricted subprograms are not allowed
> from any Pre- or Post- navigational triggers.
>
> If anyone has any ideas, I'd love to hear from you. Thanks!
Received on Mon Apr 27 1998 - 16:22:52 CEST