Re: F45 set_block_property question

From: Fraser Boswell <fraser.boswell_at_ed.ac.uk>
Date: Thu, 23 Sep 1999 10:28:46 +0100
Message-ID: <37E9F2CE.9564EB52_at_ed.ac.uk>

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

 

Received on Thu Sep 23 1999 - 11:28:46 CEST