Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic 'where' condition
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