Re: SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 30 Aug 2002 18:10:07 GMT
Message-ID: <3D6FB4E3.26E46D9E_at_exesolutions.com>


Thanks.

Daniel Morgan

justme wrote:

> set the default where to '' if you want blank
> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3D6E8744.EE538C6B_at_exesolutions.com...
> > 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
> >
Received on Fri Aug 30 2002 - 20:10:07 CEST

Original text of this message