topic syntax error while creating a invoice in Application Development and Automation Discussions

syntax error while creating a invoice

Former Member — Tue, 29 Jan 2008 12:01:11 GMT

Hi I am new to this forum hope u guys can help me out,

I am ruuning following syntax for creating an invoice and for this error message is coming which is given below.

Select a_{adrnr a}stdc1 b~name1 into table inv_head1

From kna1 as a inner join adrc as b on a_{adrnr = b}addrnumber.

Unknown column name "A~STDC1" . field list. . field list. field list.

andreas_mann3 — Tue, 29 Jan 2008 12:04:35 GMT

it must be a~stcd1

andreas_mann3 — Tue, 29 Jan 2008 12:04:43 GMT

Former Member — Tue, 29 Jan 2008 12:07:03 GMT

Hi,

I think you have wrongly typed the field name.

Currect field name is STCD1, but you have mentioned STDC1.

Please check and correct it.

Regards,

Ashok

Former Member — Wed, 30 Jan 2008 05:50:03 GMT

Hi Rupesh,

u have to mention as " select ... into corresponding fields of

table ... ".

regards

Chaitanya.