Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic 'where' condition

Re: Dynamic 'where' condition

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Fri, 14 Jan 2000 13:24:56 +0000
Message-ID: <Jj7g6BAoOyf4EwCX@ahardy.demon.co.uk>


In article <387F1199.733E328B_at_joanneum.ac.at>, Thomas Konrath <thomas.ko nrath_at_joanneum.ac.at> writes
>Hi all,!
>
>does anybody know, how do I create a dynamic 'where' condition which the
>user can input on the parameter form for my select statement?
>
>I'm unsing FROMS 4.5 and REPORTS 2.5.

The default where clause can be set using:

set_block_property('my_block', DEFAULT_WHERE, 'my dynamic clause');

Andy
>
>Thanks for your help !!!
>
>Thomas
>
>mailto:tkonrath_at_yahoo.com

--
Andy Hardy. PGP key available on request


Received on Fri Jan 14 2000 - 07:24:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US