Re: F45 set_block_property question

  "Richard Morris" <richard.morris_at_virgin.net> 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 Richard. I've had the same problem. The solution I encountered is that: every time you ave a literal put a concat (||) and then you put the literal like I did with letter 'D'

'reccobr_numero_recibo IS NULL '||
' AND multa_desconto_mora = '||'''D'''||
' AND unid_id_unidade = '||to_char(:ctrl.unid_id_unidade)

Glad to help, Leonardo Carvalho, Brazil.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 27 1999 - 22:06:42 CEST