Re: SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem

In message <3D6E8744.EE538C6B_at_exesolutions.com> , Daniel Morgan <dmorgan_at_exesolutions.com> writes
>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.

How about storing the original DEFAULT_WHERE property before you change it (using get_block_property) and reset it after use?

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849