Re: IF statement fails when it should no (PL/SQL)

From: Mike Moore <hicamel_at_mail.home.com>
Date: Sat, 17 Mar 2001 01:14:17 GMT
Message-ID: <JTys6.43603$zV3.3219506@news1.frmt1.sfba.home.com>

Not sure, but it looks to me like you are testing for NULL. NULL always fails a test for equality or inequality.

Try IF (theDoc.SDNumber is NULL) then

Again, not really sure.

Mike

don <chambers_at_inquiregroup.com> wrote in message news:pa55bt8bam061ipnf2rnipepek2aqd4cu3_at_4ax.com...
> I have the folowing if statement:
> IF (theDoc.SDNumber<>'') THEN
> ...
> END IF;
>
> The values of theDoc.SDNumber is 'test'. I can verify this by
> throwing an exception that shows this value. I never get into the
> code in the if statement allthough theDoc.SDNumber IS NOT EQUAL TO ''
> (empty string).
>
> What could cause this? Is there a different method for testing
> objects?
> I also tried using != for not equal and got the same result.
>
> Thanks,
> Don
Received on Fri Mar 16 2001 - 19:14:17 CST