Re: Forms 4.5: Button that enters & executes query

Do the following:

1. When_button_pressed trigger:

    :global.from_button := '1';
    go_block('block');
    execute_query;

2. Pre-query block trigger for "Block":

   if :global.from_button = '1' then

      copy('program%','block.item');
      copy(trunc(sysdate),'block.open_date');
      :global.from_button := '2';

T. J. wrote in message ...
>I'm trying to set up a button with a when-pressed trigger that enters
>query mode, prepopulates some query parameters (in a different block), and
>executes the query. This doesn't seem to work - the button doesn't do
>this.
>code facsimile is below. Any suggestions?
>Thanks,
>Thomas
>
>ENTER_QUERY;
>GO_ITEM('BLOCK.PROBLEM_ID');
>:BLOCK.ITEM := 'PROGRAM%';
>:BLOCK.OPEN_DATE := TRUNC(SYSDATE);
>EXECUTE_QUERY;
Received on Sun Feb 28 1999 - 01:06:06 CET