Re: Procedure based block in Forms 6.0
Date: 2000/04/24
Message-ID: <BBYM4.72$Ad.17907_at_wdc-read-01.qwest.net>#1/1
[Quoted] Use the WHERE Clause property on the block. You can hard-code it in the
[Quoted] property sheet or change it dynamically with SET_BLOCK_PROPERTY(...,
DEFAULT_WHERE,...).
"Anthony Hegarty" <ahegarty_at_eircom.net> wrote in message
news:f2UM4.7286$sB3.5259_at_news.indigo.ie...
> Hello
>
> I've been trying to use this function in a form and have used the example
> for the oracle metalink site. It is based on the emp table. What I need
to
> know is how to limit the query of the the base table to certain deptno's.
> In the example it shows that the deptno is passed as a parameter to the
> procedure that builds the plsql table on which the block is based, but it
> doesn't seem to do anything.
>
> I would be grateful for any help on this as I think it could be a very
> useful funtion of forms.
>
> Regards Anthony.
>
>
>
Received on Mon Apr 24 2000 - 00:00:00 CEST