Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Forms 4.5 :enter query mode and go_block problems

Re: Forms 4.5 :enter query mode and go_block problems

From: Peter H. Larsen <plarsen_at_dc.dynares.com>
Date: 1998/06/12
Message-ID: <3581473F.6FCD3EB0@dc.dynares.com>#1/1

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).

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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US