Re: Forms Default Query Where Clause
Date: Fri, 19 Oct 2007 10:48:59 -0000
Message-ID: <1192790939.549423.276560_at_i38g2000prf.googlegroups.com>
On Oct 18, 9:26 pm, papalph..._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?
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 Received on Fri Oct 19 2007 - 12:48:59 CEST