From: danhw@aol.com (DanHW)
Subject: Re: How to modify automatic queries created by FormBuilder
Date: 2000/08/08
Message-ID: <20000808164710.01637.00000066@ng-bh1.aol.com>#1/1
References: <3990126D.901E575E@mail.uni-mainz.de>
Organization: AOL http://www.aol.com
Newsgroups: comp.databases.oracle.tools
X-Admin: news@aol.com


>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

By using the PRE-QUERY trigger, you can change the query constructed, either by
adding/values to field items, or by modifying the block property DEFAULT_WHERE

Dan Hekimian-Williams