Re: F45 set_block_property question

From: herbert.fukerider <herbert.fukerider_at_rfn.de>
Date: Thu, 23 Sep 1999 10:07:32 +0200
Message-ID: <37E9DFC4.A020E426_at_rfn.de>

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 - 10:07:32 CEST