topic SELECT contains a direct assignment in Application Development and Automation Discussions

SELECT contains a direct assignment

Former Member — Tue, 10 Jul 2007 06:34:24 GMT

Hi,

In code checker i m getting the following warning :- <b>SELECT contains a direct assignment.</b>

for the below select query.

<b>select single kalsm into W_procedure from t005 where land1 = ttx_txjcd-country</b>.

can anyone help me in it.

Regards,

Nithya

Re: SELECT contains a direct assignment

KjetilKilhavn — Tue, 10 Jul 2007 07:42:58 GMT

You have not given the data definition of w_procedure. You have not given the data definition of ttx_txjcd. How do you expect us to know what your problem is?

Besides, I can't recall ever seeing a warning or error in the code inspector (I assume this is where you get the warning) without a link to further infomation explaining why the message is issued.

Re: SELECT contains a direct assignment

seshatalpasai_madala — Tue, 10 Jul 2007 07:48:12 GMT

Hi,

What is the type of W_procedure.

If its the same type as kalsm there should not be any problem, but if W_procedure is of type t005 or any other strucutre you need to use CORRESPONDING FIELDS OF addition.

Regards

Sesh

Re: SELECT contains a direct assignment

Former Member — Tue, 10 Jul 2007 09:57:41 GMT

good

this error can be avoided using "#EC with the line.

thanks

mrutyun^