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
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