Re: Check if text item is NULL?
From: Javier Rojas <jrv_at_sansol.com>
Date: Mon, 19 Apr 1999 11:24:05 +0200
Message-ID: <371AF635.9E9D06AB_at_sansol.com>
Date: Mon, 19 Apr 1999 11:24:05 +0200
Message-ID: <371AF635.9E9D06AB_at_sansol.com>
Hi Vagelis,
Try this:
IF :block_name.text_item_name IS NULL then
...
ELSE
...
END IF;
Aaaaadios,
Javier Rojas.
vagelis Hristidis wrote:
>
> I use Forms 5.0.
> message('###'||:block_name.text_item_name||'###');
> IF(:block_name.text_item_name=NULL)
> then
> message('NULL');
> message('');
> else
> message('NOT NULL');
> message('');
> end if;
>
> When the above code is executed and text_item_name is empty I get 2 message
> boxes
> 1st) ######
> 2nd)'NOT NULL' !!!!!!!!!!!!!!!!!!!!????????????
>
> How can I check if a string is null?
> Thanks in advance.
> Vagelis
Received on Mon Apr 19 1999 - 11:24:05 CEST