Re: SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem
Date: Thu, 29 Aug 2002 23:09:00 GMT
Message-ID: <gQxb9.39996$6m61.31410_at_news04.bloor.is.net.cable.rogers.com>
[Quoted] 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 - 01:09:00 CEST