Comma without preceding colon (after SELECT ?).

[Former Member]

HI Experts . I have a problem with my smartform it is showing error as

Comma without preceding colon (after SELECT ?).

my code is

select single rmwwr lifnr budat from rbkp

into (z_rmwwr,

z_lifnr,

z_budat)

where belnr = z_belnr

and gjahr = z_gjahr.

select single name1 stras ort01 ort02 pstlz from lfa1

into (z_name1,

z_stras,

z_ort01,

z_orto2,

z_pstlz)

where lifnr = z_lifnr.

[Former Member]

Hi Nickel,

it's pretty hard to tell from that small snippet. But, have you noticed the "z_orto2" in the 2nd select statement. Shouldn't it be "z_ort02"? I mean, the variable that you've declared is "z_orto2" or "z_ort02"?

Kind regards,

Alvaro

[SuhaSaha]

Did you pass the input & the output params in the code block ?

[Former Member]

Nickel ,

I have check ur code at my system through se38 report. But it didn't give any error.

can u confirm me your error once again where it is occurring.

[Former Member]

Hi Nickel,

select single rmwwr lifnr budat from rbkp

into (z_rmwwr, z_lifnr, z_budat)

where belnr = z_belnr

and gjahr = z_gjahr.

select single name1 stras ort01 ort02 pstlz from lfa1

into (z_name1, z_stras, z_ort01, z_orto2, z_pstlz)

where lifnr = z_lifnr.

1. There should be no gaps inbetween the brackets and the first variable.

2. There should be gap between , and the next variables.

Hope it helps.

Sujay

[Former Member]

Hi..

Check the following 2 points:

1. Declare the input output parameters.

2. There should not be space between '(' and 'z_name1' as in INTO (Z_NAME1,---)

Although there is no space in this post, but it may exist in your smartform. When I intentionally gave that space, the error occurred which otherwise didn't.

Spaces between ',' and other variables do not matter. Its just regarding the first variable.

Regards,

Karthik

[Former Member]

HI

I tried all the possibilities you informed me.

Also I passed input and output parameters.

[Former Member]

Maybe you have an error somewhere else. Comment out those two selections and do a syntax check.

[Former Member]

I have commented select statement and rewrite the code again. and issue is solved.

Thanks for u all for helping me.

[Former Member]

Ravindranath reddy ,

I have check ur code at my system through se38 report. Problem in your code is that you not give space between into and bracket . Give space in into and bracket .

select single rmwwr lifnr budat from rbkp

into  (z_rmwwr, z_lifnr, z_budat)

where belnr = z_belnr

and gjahr = z_gjahr.

[Former Member]

Ravindranath reddy ,

I have check ur code at my system through se38 report. Problem in your code is that you not give space between into and bracket . Give space in into and bracket .

select single rmwwr lifnr budat from rbkp

into  (z_rmwwr, z_lifnr, z_budat)

where belnr = z_belnr

and gjahr = z_gjahr.