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: form query problem

Re: form query problem

From: Robin Quasebarth <robinq_at_data-point.com>
Date: 1998/11/09
Message-ID: <3646A65C.65ADF639@data-point.com>#1/1

Create non-database fields in the first block to enter query criteria for the other items in the detail blocks. Create a pre-query trigger at the block level of the detail blocks and have the trigger stuff the non-database field values into the appropriate form items and that should work. rq

ªü´ö Thenardier wrote:

> hi,
>
> there is a form which has 2 items on the top of it and a detail
> block at the bottom. in enter query mode, the user should be
> able to input search values, say, "%", in that 2 items *and* in
> some columns in the detail block. the 2 items and the details are
> in different blocks. i find that, enter query only allows users
> to input search values in *one* block only. if the items for
> queries come different, enter query seems have no use.
>
> am i right? how to handle it, then?
>
> thanx in advance.
> thenard
> -------
> pls remove pk. in reply, thanx.
> ¦^ÂЮɽЧâpk. K ±¼, ÁÂÁÂ.
Received on Mon Nov 09 1998 - 00:00:00 CST

Original text of this message

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