From: Stefan Röhle <roehle@mail.uni-mainz.de>
Subject: How to modify automatic queries created by FormBuilder
Date: 2000/08/08
Message-ID: <3990126D.901E575E@mail.uni-mainz.de>#1/1
Content-Transfer-Encoding: 7bit
X-Accept-Language: de
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: usenet@mail.uni-mainz.de
X-Trace: bambi.zdv.Uni-Mainz.DE 965743215 8006 134.93.179.107 (8 Aug 2000 14:00:15 GMT)
Organization: Zentrum für Datenverarbeitung -  Universität Mainz
Mime-Version: 1.0
Reply-To: roehle@mail.uni-mainz.de
NNTP-Posting-Date: 8 Aug 2000 14:00:15 GMT
Newsgroups: comp.databases.oracle.tools


Hi,

I have created a Form using FormBuilder. Everything works fine, but now
I'd like to implement a special query:
When you enter for example '100' in the field PRICE and you press the
'Query'-button, all matching entries in the database are found.
Now I'd like to display those data too whose PRICE equals '-100' (and
vice versa).
To sum it up:
I want to modify the original query created by formbuilder
(something like: select * from table where table.price = 100)
into
(select * from table where abs(table.price) = 100).
But how can I do this?

Thanks

Stefan

PS: PLease reply via email as well.