Forms Default Query Where Clause

#1

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?

#2

papalphaus (AT) yahoo (DOT) com wrote:

Quote:

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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#3

On Oct 18, 9:26 pm, papalph... (AT) yahoo (DOT) com wrote:

Quote:

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?

Enter in field A the value :a and in fiel B the value :b
execute the query and you will get a popup window.
here you can add your extention to the default where.

In stead of :a you can also use & and # to add some code to the
default where.

A lot of applications don't allow the use of :,& and # as first
character for safety, the text

"1=1 ) or (1=1" in the popup window gives you a query where de default
where would be ignored

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Forms Default Query Where Clause

comp.databases.oracle.tools comp.databases.oracle.tools

Forms Default Query Where Clause - 10-18-2007 , 02:26 PM

Re: Forms Default Query Where Clause - 10-18-2007 , 08:05 PM

Re: Forms Default Query Where Clause - 10-19-2007 , 05:48 AM