topic Re: Error in Select statement in Application Development and Automation Discussions

Error in Select statement

Former Member — Mon, 14 Sep 2009 10:47:38 GMT

Hi,

I need to fetch both dynamic as well as static fields. When i tried this query it gives me error.

select trkeynr

(p_stat)

from k810008

into table git_k8

for all entries in git_k7

where trkeynr eq git_k7-trkeynr

and gjahr eq p_year

and perde eq p_period.

==========

Whereas if i simply select only the dynamic fields, it doesnt give any error. like this

select (p_stat)

from k810008

into table git_k8

for all entries in git_k7

where trkeynr eq git_k7-trkeynr

and gjahr eq p_year

and perde eq p_period.

Cant we use both dynamic field selection and static field se

Re: Error in Select statement

Former Member — Mon, 14 Sep 2009 10:52:44 GMT

Hi,

Yes you can use both static as well as dynamic fields in the select statement at the same time. Try using INTO CORRESPONDING FIELDS OF TABLE addition in the select query and check if its working,


select trkeynr
(p_stat)
from k810008
into INTO CORRESPONDING FIELDS OF TABLE git_k8
for all entries in git_k7
where trkeynr eq git_k7-trkeynr
and gjahr eq p_year
and perde eq p_period.

Also make sure you dont enter the same field trkeynr in p_stat.

Regards,

Vikranth

Re: Error in Select statement

Former Member — Mon, 14 Sep 2009 10:58:54 GMT

Hi ,

Instead why dont you try as follows

concatenate trkeynr p_stat into p_stat separated by space .

select (p_stat) from ...

Thanks

Re: Error in Select statement

Former Member — Mon, 14 Sep 2009 11:00:48 GMT

Vikrant,

No, it is not working.

Re: Error in Select statement

Former Member — Mon, 14 Sep 2009 11:09:35 GMT

Hi,

As supriya stated use the concatenate statement, It will work

regards

Pavan