Re: How to modify automatic queries created by FormBuilder

Use the Pre-Query trigger and the Set_Block_Property(block_name, DEFAULT_WHERE, where-clause) function. Or, put the price field in a control block (non-database block); refer to the field in the data block's WHERE_CLAUSE property as 'abs(price) = :control_block.price'.

"Stefan Röhle" <roehle_at_mail.uni-mainz.de> wrote in message news:3990126D.901E575E_at_mail.uni-mainz.de...
> 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.
Received on Wed Aug 09 2000 - 00:00:00 CEST