SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 29 Aug 2002 20:43:10 GMT
Message-ID: <3D6E8744.EE538C6B_at_exesolutions.com>

[Quoted] [Quoted] 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 Thu Aug 29 2002 - 22:43:10 CEST