Re: Procedure based block in Forms 6.0

[Quoted] Without seeing Oracle's code it is hard to answer "why?" But, it does seem unnecessary to BUILD a table for the block if the emp table already exists and can be limited with a where clause. I must not be understanding something.

But the WHERE clause property becomes an actual WHERE clause in the SQL query sent to the database engine. The result set is limited at the server/database, not at the Form.

"Anthony Hegarty" <ahegarty_at_eircom.net> wrote in message news:OZ_M4.7357$sB3.5287_at_news.indigo.ie...
> Thanks for answering,
>
> That's one way of doing it, but why in the example do Oracle show that you
> can pass a parameter to the procedure when it does nothing? You can see in
> the query-procedure trigger created by the form that it does pass in a
> parameter and I thought that this is based on the blocks
> query-data-source-arguments in the blocks properties. What are these for
 if
> not to pass parameters to the procedure ? Any ideas?
>
> If I do it this way is the plsql block filled with all the details and
 then
> the form limits what is retrieved. If this is so, it won't be much good
 to
> me as the table I want to base this on will have millions of rows.
>
> Anthony.
>
> Anthony.
> Mike Dwyer <dwyermj_at_co,larimer.co.us> wrote in message
> news:BBYM4.72$Ad.17907_at_wdc-read-01.qwest.net...
> > Use the WHERE Clause property on the block. You can hard-code it in the
> > 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