Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!212.84.206.1.MISMATCH!bolzen.all.de!newsfeed.stueberl.de!newsr1.ipcore.viaginterkom.de!btnet-peer1!btnet-peer0!btnet-feed5!btnet!bt !not-for-mail
From: URNinja-ed <LCIYQBBEQVFA@spammotel.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: SET_BLOCK_PROPERTY - DEFAULT_WHERE Problem
Date: Thu, 12 Dec 2002 10:51:48 +0000
Organization: BT 
Lines: 44
Message-ID: <3DF86A43.76C0027F@spammotel.com>
References: <3D6E8744.EE538C6B@exesolutions.com> <2271769.1039679133@dbforums.com>
NNTP-Posting-Host: 10.239.46.99
Mime-Version: 1.0
Content-Type: text/plain; charset=x-user-defined
Content-Transfer-Encoding: 8bit
X-Trace: pheidippides.axion.bt.co.uk 1039690711 27520 10.239.46.99 (12 Dec 2002 10:58:31 GMT)
X-Complaints-To: postmaster@axion.bt.co.uk
NNTP-Posting-Date: 12 Dec 2002 10:58:31 GMT
X-Accept-Language:  en
X-Mailer:  Mozilla 4.7 [en-gb]C-CCK-MCD   (WinNT; U)
Xref: newsfeed1.easynews.com comp.databases.oracle.tools:55337
X-Received-Date: Thu, 12 Dec 2002 03:51:42 MST (news.easynews.com)

strange... the obvious answer is:

set_block_property(<block_name>, default_where, '');

and it works for me fine.

iam_narayanan wrote:

> 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

--
Suzuki SV650S - plop.  Gone.
Kwak ZX-6R J2 - hear the roar