topic Re: problem with logical or in Application Development and Automation Discussions

problem with logical or

Former Member — Fri, 29 Jan 2010 05:22:21 GMT

hi friends i am using OR in a select statement like this :

select single KAWRT from KONV into var2 where KNUMV = var1 and STUNR = 65 or STUNR = 60 .

but what i want is that the result for this should be calculated as

KNUMV =var1 and (STUNR = 65 or STUNR =60)

means result of STUNR = 65 or STUNR =60 should be AND with KNUMV =var1

when i tried like following :

select single KAWRT from KONV into var2 where KNUMV = var1 and STUNR =( 65 , 60)

it is giving error.is there something wrong.

Re: problem with logical or

amit_khare — Fri, 29 Jan 2010 05:28:19 GMT

Replace '=' with 'IN'..

Re: problem with logical or

former_member206377 — Fri, 29 Jan 2010 05:29:35 GMT

Hi Achal,

Have you tried this ?


      SELECT  SINGLE kawrt
             FROM konv
             INTO var2
             WHERE knumv = var1 AND
                    (  stunr = '65' OR stunr = '60' ) .

Re: problem with logical or

Former Member — Fri, 29 Jan 2010 05:30:09 GMT

Hello

Try this:


select single KAWRT from KONV into var2 where 
KNUMV = var1 and ( STUNR = '65' OR STUNR =  '60' ).

Re: problem with logical or

Former Member — Fri, 29 Jan 2010 05:33:40 GMT

Hi Anchal,

select single KAWRT from KONV into var2 where KNUMV = var1 and ( STUNR = 65 or STUNR = 60 )

Manas M.

Re: problem with logical or

Former Member — Fri, 29 Jan 2010 05:37:37 GMT

hi,

use IN operator instead of EQ.