topic Re: Syntax error - where condition may contain nulls in Application Development and Automation Discussions

Syntax error - where condition may contain nulls

Former Member — Fri, 26 May 2006 19:20:11 GMT

I get the message that the condition may contain nulls. How do I correct this?

select *

from resb

where rsnum = s_resit+0(10)

and matnr = s_zresb_material1

and bwart <> '531'.

endselect.

Thanks

Re: Syntax error - where condition may contain nulls

RichHeilman — Fri, 26 May 2006 19:26:00 GMT

This is just a warning message. You can ignore it.

Regards,

Rich Heilman

Re: Syntax error - where condition may contain nulls

Former Member — Fri, 26 May 2006 19:48:40 GMT

Thanks, Rich. This won't cause any problems while executing?

I will award points.

Re: Syntax error - where condition may contain nulls

RichHeilman — Fri, 26 May 2006 19:51:34 GMT

No. I have gotton that warning message when working with RESB before, in my case it was the VORNR field. I have never had any problems with any of the programs.

To be perfectly honest, I don't know why that message comes, just that it doesn't cause me any problems, so I let it slide.

Regards,

Rich Heilman