Re: Is is possible in forms6 ?

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/05/25
Message-ID: <sirtk8amo165_at_corp.supernews.com>#1/1


"Markus Schwabe" <mschwabe_at_gscout.de> wrote in message news:8gdu58$eds$1_at_news4.muc.eurocyber.net...
> IF :<BlockName1>.<ItemName1> != :<BlockName2>.<ItemName2> THEN
> ...
> ELSE
> ...
> END IF;
You can do that if both fields are non-null but if they can be null, and you want a null to be evaluated as not equal to a non-null value, you have to do this:

IF (:<BlockName1>.<ItemName1> IS NOT NULL AND
    :<BlockName2>.<ItemName2> IS NOT NULL AND
    :<BlockName1>.<ItemName1> != :<BlockName2>.<ItemName2>) OR
 (:<BlockName1>.<ItemName1> IS NULL AND

    :<BlockName2>.<ItemName2> IS NOT NULL) OR  (:<BlockName1>.<ItemName1> IS NOT NULL AND

    :<BlockName2>.<ItemName2> IS NULL) THEN   ...
ELSE
  ...
END IF; -Matt Received on Thu May 25 2000 - 00:00:00 CEST

Original text of this message