Re: F45 set_block_property question
Date: Thu, 23 Sep 1999 10:11:39 +0200
Message-ID: <37E9E0BB.E9F60261_at_cnt.pl>
You have to use '' (double ').
Last parameter of SET_BLOCK_PROPERTY must be:
'(refid = :global.ref and clear = ''N'' or subref not like ''%clr'')'
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;
>
> but as soon as the first literal is encountered, the ' is read as the end of
> the default where.
>
> I've tried many combinations using ' " and () without any success.
> I have actually got around this by declaring the literals as global
> variables and substituting their values for :global.var1 and :global.var2 in
> the sql, but I'd be grateful to know how to deal with quotes in sql.
>
> TIA
>
> Richard
>
> richard.morris_at_virgin.net
-- ___ / \ ___ Adam Czerski Centrum Nowych Technologii | |\ | | mailto:czadam_at_cnt.pl ul. Uphagena 2, 80-237 Gdansk | | \| | tel/fax. (0-58) 3455545 ** www.cnt.pl ** www.wp.pl ** \___/Received on Thu Sep 23 1999 - 10:11:39 CEST