topic Re: ERROR EXECUTING CODE IN SMARTFORM PROGRAM LINE in Application Development and Automation Discussions

ERROR EXECUTING CODE IN SMARTFORM PROGRAM LINE

Former Member — Mon, 10 Jul 2006 13:20:37 GMT

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 — Mon, 10 Jul 2006 13:25:13 GMT

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 — Mon, 10 Jul 2006 13:25:32 GMT

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 — Thu, 08 Mar 2007 01:26:58 GMT

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.