Xref: alice comp.databases.oracle.tools:32347 Path: alice!news-feed.fnsi.net!enews.sgi.com!news-feed.inet.tele.dk!bofh.vszbr.cz!nntp.news.xara.net!xara.net!gxn.net!server6.netnews.ja.net!newsfeed.ed.ac.uk!not-for-mail From: Fraser Boswell Newsgroups: comp.databases.oracle.tools Subject: Re: F45 set_block_property question Date: Thu, 23 Sep 1999 10:28:46 +0100 Organization: Edinburgh University Lines: 94 Message-ID: <37E9F2CE.9564EB52@ed.ac.uk> References: <7sbafl$kc3$1@nclient15-gui.server.virgin.net> <37E9DFC4.A020E426@rfn.de> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------------C006E4549EC8E045416E0E88" X-Trace: scotsman.ed.ac.uk 938078706 2366 129.215.180.146 (23 Sep 1999 09:25:06 GMT) X-Complaints-To: usenet@scotsman.ed.ac.uk NNTP-Posting-Date: 23 Sep 1999 09:25:06 GMT X-Mailer: Mozilla 4.5 [en] (Win95; I) X-Accept-Language: en --------------C006E4549EC8E045416E0E88 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit If it's not the closing bracket that's the problem, you can try replacing the quote with chr(39) so it would be
'(refid = :global.ref and clear = ' || chr(39) || 'N' || chr(39)|| ' or subref not like ' || chr(39) ||'%clr' || chr(39) ||')');
I think, i may be missing a ) somewhere too.
I just had to build a big default where based on 6 fields, and I got it to work using chr(39) this way.
Hope this helps

Fraser

"herbert.fukerider" wrote:

Richard Morris wrote:
I need to set a default where on a block property according to a global
variable.
The code I tried was:
IF :global.id not in ('xxxx', 'yyyy') THEN
SET_BLOCK_PROPERTY ('block1',default_where,'(refid = :global.ref and
clear = 'N'
or subref not like '%clr')';
end if;

Hi,

is there a missing closing bracket in SET_BLOCK_PROPERTY( ) ?

try to set up a varchar2 variable with your where_clause

and use this var in SET_BLOCK_PROPERTY( )
double quote your < ' > within your where_clause

Hope this will help you.
H.Fukerider

--------------C006E4549EC8E045416E0E88--