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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Forms Default Query Where Clause

Re: Forms Default Query Where Clause

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 18 Oct 2007 18:05:42 -0700
Message-ID: <1192755931.527310@bubbleator.drizzle.com>


papalphaus_at_yahoo.com wrote:
> Is there a way in Oracle forms for the default query (in Enter Query
> mode) to produce a where clause with field A OR field B, instead of
> the default of field A AND field B when filling in values for fields A
> and B?

Create your block based on a procedure rather than a table.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Oct 18 2007 - 20:05:42 CDT

Original text of this message

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