Re: Forms 4.5 :enter query mode and go_block problems

Huh??
You cannot move out of a block in querymode. If you want to refer to values in another block, then do so ... like :block1.field. You can easily refer to fields in blocks others than the block being queried.

If you need to do some SELECT statements, do that in the PRE-QUERY trigger.

I have never had the usage of moving to another block while in query mode, other than to allow the USER to enter some query conditions other places (but there are solutions to that problem).

• Peter H. Larsen oracle Consultant

Bratke wrote:
>
> Hi there,
> I have a problem.
> My application is in 'enter query' mode and i want to make a 'go_block'
> command. But this is an restricted function. What can i do ?
> I want to change the block and select a value from the new block and copy
> this value in the first block to use this value in the where-clause.
>
> Hope someone can help me !
>
> Regards Gerd
  Received on Fri Jun 12 1998 - 00:00:00 CEST