topic Re: Syntax error while writing a select query. in Application Development and Automation Discussions

Syntax error while writing a select query.

Former Member — Fri, 13 Mar 2009 21:06:32 GMT

Hi all,

I have a requirement where I have to pick a value if the text for that value is

MYCARu2019S Lovliest Car.

And so I wrote a query that


SELECT	RUECK INTO XRUECK FROM AFVC WHERE ltxa1 = ' MYCARu2019S Lovliest Car'.
                ENDSELECT.

But it gives me a syntax error saying

u201CLiterals taking up more than one line not permittedu201D.

Can some one tell me what is wrong. I need to select RUECK value from AFVC table if

ltxa1 value is ' MYCARu2019S Lovliest Car'.

Kindly help what is going wrong...

Regards,

Jessica Sam

Re: Syntax error while writing a select query.

Former Member — Fri, 13 Mar 2009 21:10:11 GMT

Hi,

Give two single quotes..

SELECT  rueck INTO xrueck FROM afvc WHERE ltxa1 = ' MYCAR''S Lovliest Car'.
ENDSELECT.

Thanks

Naren

Re: Syntax error while writing a select query.

Former Member — Fri, 13 Mar 2009 21:17:56 GMT

Try the below code in the where condition.

' MYCARu2019'S Lovliest Car'.

Mathews

Re: Syntax error while writing a select query.

Former Member — Fri, 13 Mar 2009 21:21:19 GMT

Thanks Mathew and Narendar.

Solved with your suggestion.

Regards,

Jessica Sam

Re: Syntax error while writing a select query.

Former Member — Fri, 13 Mar 2009 21:21:54 GMT

To add to what Naren has pointed out: the ABAP syntax checker always looks for an even number of quotes in code and if it finds an odd number, it assumes that the last one was never closed and goes over multiple lines. The double quotes is a trick that goes back quite a while to fool the syntax checker.

Rob

Re: Syntax error while writing a select query.

faisalatsap — Fri, 13 Mar 2009 21:22:35 GMT

Hi,

Narendran is right use two single quotes.

also careful wile comparing string. i think as you write ltxa1 value is ' MYCARu2019S Lovliest Car'.

so while comparing you must not use space just before staring use the following

SELECT  rueck INTO xrueck FROM afvc WHERE ltxa1 = 'MYCAR''S Lovliest Car'. " Not use Space before M
ENDSELECT.

Hope will help you.

Kind Regards,

Faisal