ERROR EXECUTING CODE IN SMARTFORM PROGRAM LINE

[Former Member]

HII FRNDS PL HELP ME WID THIS .. I AM GETING AN AS Comma without preceding colon (after SELECT ?). WHILE

data : t_DOCNO TYPE J_1IEXCHDR-DOCNO .

select SINGLE DOCNO into t_DOCNO from J_1IEXCHDR

where exnum = gf_text AND

status NOT IN ( 'D' , 'R' , 'B' ).

select SINGLE EXBAS EXBED ECS

into ( t_exbas , t_exbed , t_ecs )

from J_1IEXCDTL

where exnum = gf_text and

docno = t_docno .

[Former Member]

try with removing space between field & comma in into

select SINGLE EXBAS EXBED ECS

into ( <b>t_exbas,

t_exbed,

t_ecs</b> )

from J_1IEXCDTL

where exnum = gf_text and

docno = t_docno .

[Former Member]

Hello In the second select stmt.

select SINGLE EXBAS EXBED ECS

into (t_exbas,t_exbed,t_ecs)

from J_1IEXCDTL

where exnum = gf_text and

docno = t_docno .

Copy and paste this code.

If will not get the error.

IF useful reward points.

Regards,

Vasanth

[Former Member]

Hi ROHIT GUPTA,

try this one

select SINGLE DOCNO into t_DOCNO from J_1IEXCHDR

where exnum = gf_text AND

status NOT IN ('D' , 'R' , 'B' ).

with ('D' but not ( 'D'

the space can make that error.