Re: forms problem

If you are going to programatically execute a query using particaular values in some of the fields on the form, it is done in the following manner.

The current block needs to be the block you are going to perform the query on. To execute the query with the values you want, you need to update the default_where property for the block. After you have performed the query, you will need to set the default where property back to what it was.

Following is some example code.

    go_block('block_name');

    tmp_where := get_block_property('block_name',default_where);

     set_block_property('block_name',default_where,'where clause for query');

    execute_query;

    set_block_property('block_name',default_where,tmp_where);

Hope this helps,

Sarah

Martin Meadows <mmeadows_at_indy.net> wrote:

>Based on various responses from Oracle folks I now think I have to do
>the following:
>
>I think I need to force a requery on screen 1. I know the following
>works if I do it manually.
>Clear Record
>Enter Query
><enter fields>
>Execute Query
>
>I would like to be able to do the above 3 commands programmatically.
>I know Clear_Record; works fine.
>I also know that if I use Enter_Query; it sits & waits on input. I
>don't want to force the operator to re-enter data. I want to get into
>query mode & then Execute_Query; but I don't know how to make this
>happen in pl/sql. Can you tell me how this is done?
>
>Thanks again,
>Martin Meadows
Received on Thu May 28 1998 - 01:29:22 CEST