Re: Forms 4.5: Button that enters & executes query

Hi,

I think, you are in the wrong Block.
The correct order of your commands must be:

GO_ITEM('BLOCK.PROBLEM_ID');
ENTER_QUERY;
:BLOCK.ITEM := 'PROGRAM%';
:BLOCK.OPEN_DATE := TRUNC(SYSDATE);
EXECUTE_QUERY; Rainer Bielefeld

"T. J." wrote:
>
> 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 Mon Mar 01 1999 - 16:48:02 CET