topic Re: Error with select statement in Application Development and Automation Discussions

Error with select statement

Former Member — Wed, 17 Dec 2008 18:15:44 GMT

Hi All,

I am getting the error 'Comma without preceding colon (after SELECT ?).' with the following select statement. Can someone help me with the error.

select single actdate_from actdate_to

into ( lv_actdate_from, lv_actdate_to )

from zsdcoop

where kunnr = wa-kunnr and pfnum = wa-pfnum.

if ( lv_actdate_from NE wa-actdate_from ) or ( lv_actdate_to NE wa-actdate_to ).

wa-block = 'X'.

Endif.

Thanks,

Veni.

Re: Error with select statement

Former Member — Wed, 17 Dec 2008 18:18:33 GMT

if  lv_actdate_from NE wa-actdate_from  or 
 lv_actdate_to NE wa-actdate_to .
wa-block = 'X'.
Endif.

Re: Error with select statement

amit_khare — Wed, 17 Dec 2008 18:19:51 GMT

Remove the spaces after & before brackets.

select single actdate_from actdate_to

into (lv_actdate_from, lv_actdate_to)

from zsdcoop

where kunnr = wa-kunnr and pfnum = wa-pfnum

Re: Error with select statement

suresh_datti — Wed, 17 Dec 2008 18:21:44 GMT


>         select single actdate_from actdate_to
>         into (lv_actdate_from, lv_actdate_to)
>         from zsdcoop
>         where kunnr = wa-kunnr and pfnum = wa-pfnum.
> Veni.

you could have tried it yourself.

~Suresh

Re: Error with select statement

Former Member — Wed, 17 Dec 2008 18:28:22 GMT

Typically, on statements like this, you want to use AND instead of OR. Google "truth tables" for a detailed explanation of why.

if ( lv_actdate_from NE wa-actdate_from ) or ( lv_actdate_to NE wa-actdate_to ).
wa-block = 'X'.

Should probably be:

if ( lv_actdate_from NE wa-actdate_from ) AND ( lv_actdate_to NE wa-actdate_to ).
wa-block = 'X'.