(unknown charset) Re: SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem

strange... the obvious answer is:

set_block_property(<block_name>, default_where, '');

and it works for me fine.

iam_narayanan wrote:

> This is regarding Orderby in an control block or non base table block
> using set_block_property(<blockname>,default_where,<?>')
> can u help on this.
>
> Originally posted by Daniel Morgan
> > Finally ran into something where neither HELP, nor Oracle docs,
> > nor my book
> > collection seems to be able to provide an answer or a workaround.
> >
> > Has anyone figured out how to get past this in Oracle Froms 6i?
> >
> > SET_BLOCK_PROPERTY('permit_request', DEFAULT_WHERE,
> > 'permit_request_no = ' ||
> > :workorder_permit.permit_request_no);
> >
> > Alters the default WHERE clause and adds the above parameter ...
> > good so far.
> >
> > But there seems to be no way to get back to the default WHERE clause.
> > Which in most
> > cases for this particular form is no WHERE clause at all.
> >
> > Any suggestions welcome.
> >
> > Thanks,
> >
> Daniel Morgan
>
> --
> Posted via http://dbforums.com

--
Suzuki SV650S - plop.  Gone.
Kwak ZX-6R J2 - hear the roar