Re: SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem

[Quoted] 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