cancel
Showing results for 
Search instead for 
Did you mean: 

select column statement

Former Member
0 Kudos

Hi experts

I am trying to select specifed column in smartform statement but geeting error

"Comma without preceding colon (after SELECT ?)." but same statent is working in report . please let me know what is the reasion of the same .

SELECT SINGLE persnumber

addrnumber

FROM usr21

into ( g_persnumber,g_addrnumber )

where bname eq 'DDIC' .

DDIC is a value of usr21 table .

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for your Quick reply

former_member195383
Active Contributor
0 Kudos

Hi Ajay,

The problem is with ur sapcing of fields within brackets.

write ur query like

SELECT SINGLE persnumber addrnumber

FROM usr21

into (g_persnumber, g_addrnumber)

where bname eq 'DDIC' .

Notice thr is no space just after and before the braces.After comma give one space.

It will work for u.

Regards

Rudra

former_member196280
Active Contributor
0 Kudos

If you have problem write it like this...

SELECT SINGLE *

FROM usr21

where bname eq 'DDIC' .

g_persnumber = persnumber

g_addrnumber = addrnumber

Regards,

SaiRam