topic Re: problem with select single statement in Application Development and Automation Discussions

problem with select single statement

Former Member — Thu, 05 Apr 2007 05:33:24 GMT

Hi friends,

Is there any thing wrong with the coding

SELECT SINGLE podate

poamount

vendorinv

vendordes

INTO ( V_podate,

V_poamount,

V_vendorinv,

V_vendordes )

FROM zpo_input

WHERE ponumber = zpo_input-ponumber.

I get a error message Comma without preceding colon (after SELECT ?).

pls suggest me how to do,

Line

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:35:31 GMT

Try this..

u have to give space after each comma and the braces

SELECT SINGLE podate
poamount
vendorinv
vendordes
INTO ( V_podate , V_poamount , V_vendorinv , V_vendordes )
FROM zpo_input
WHERE ponumber = zpo_input-ponumber.

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:36:15 GMT

Hi just try this code

<b>

SELECT SINGLE podate

poamount

vendorinv

vendordes

INTO (V_podate, " Just remove the space bt '(' and 'V'

V_poamount,

V_vendorinv,

V_vendordes) " Just remove the space bt 's' and ')'

FROM zpo_input

WHERE ponumber = zpo_input-ponumber.</b>

It will definitely work

If it helps reward with points

Regards Rk

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:37:10 GMT

Line,

Just adjust the bracket...Copy the code now.

SELECT SINGLE podate

poamount

vendorinv

vendordes

INTO (V_podate,

V_poamount,

V_vendorinv,

V_vendordes)

FROM zpo_input

WHERE ponumber = zpo_input-ponumber.

Don't forget to reward if useful....

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:37:19 GMT

hi,

wtite in this way

SELECT SINGLE podate

poamount

vendorinv

vendordes

INTO (V_podate,

V_poamount,

V_vendorinv,

V_vendordes)

FROM zpo_input

WHERE ponumber = zpo_input-ponumber.

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:37:24 GMT

Hi Line ,

Is there a space after the open bracket ( and before the ).

If yes please remove it.

Regards

Arun

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:38:15 GMT


SELECT SINGLE podate
poamount
vendorinv
vendordes
INTO ( V_podate, V_poamount, V_vendorinv, V_vendordes )
FROM zpo_input
WHERE ponumber = zpo_input-ponumber.

after comma one space

regards

shiba dutta

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:39:12 GMT

There shouldn't be a spacing in between ( and V_podate, same goes to V_vendordes and )


SELECT SINGLE podate
poamount
vendorinv
vendordes
INTO (V_podate,
V_poamount,
V_vendorinv,
V_vendordes)
FROM zpo_input
WHERE ponumber = zpo_input-ponumber.

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:39:46 GMT

Hi,

Try this:

DATA wa TYPE spfli.

SELECT carrid connid cityfrom cityto

FROM spfli

INTO (wa-carrid, wa-connid, wa-cityfrom, wa-cityto).

WRITE: / wa-carrid, wa-connid, wa-cityfrom, wa-cityto.

ENDSELECT.

Important: note SPACE given specially in INTO clauuse.

Hope this will help.

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:39:50 GMT

Hi,

SELECT SINGLE podate

poamount

vendorinv

vendordes

INTO (V_podate, <b>" Delete Space before V_podate</b>

V_poamount,

V_vendorinv,

V_vendordes )

FROM zpo_input

WHERE ponumber = zpo_input-ponumber.

regards,

ananth

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:41:04 GMT

Hi..,

When u are using INTO (....)...

The spaces should be in correct order...

check this.. into (mara-matnr, mara-ernam, mara-ersda ).

check the spaces in this statement !!!

After the first bracket and first variable there should not be any space and .. after the variable and comma no space should be there !! .

reward if it helps u...

sai ramesh

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:45:53 GMT

I get the message like this,

The list "(V_PODATE" after "INTO" is not of the form (f1, ...,fn), or

contains an undefined field. excludes specification of a field list.

Pls correct me

Regards,

Line

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:50:22 GMT

hi,

is this table "zpo_input" defined by u.

then check it.

SELECT SINGLE podate poamount vendorinv vendordes INTO (V_podate,V_poamount,V_vendorinv,V_vendordes) FROM <DB table>

WHERE ponumber = zpo_input-ponumber.

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:50:27 GMT

have u also tried givinng spaces after commas

SELECT SINGLE podate
poamount
vendorinv
vendordes
INTO (V_podate , V_poamount , V_vendorinv , V_vendordes)
FROM zpo_input
WHERE ponumber = zpo_input-ponumber.

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:51:36 GMT

just copy and paste this


SELECT SINGLE podate
poamount
vendorinv
vendordes
INTO (V_podate, V_poamount, V_vendorinv, V_vendordes)
FROM zpo_input
WHERE ponumber = zpo_input-ponumber.

only one space after the comma no gap between brackets..

regards

shiba dutta

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 05:53:11 GMT

Remove the space between bracket and V and also give space ion your where condition

Thnks

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 06:03:26 GMT

Hi Tried,

All the ways but i am unable to correct,

The list "(V_PODATE" after "INTO" is not of the form (f1, ...,fn), or

contains an undefined field. excludes specification of a field list.

Regards,

Line

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 06:08:06 GMT

check if u have declared all the 4 fields

V_podate , V_poamount , V_vendorinv , V_vendordes

also double click on that error and check if it occurs on the select statement only

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 06:09:47 GMT

i dont know why it is not giving you the error.


data v_pono like zpo_input-ponumber.

v_pono = zpo_input-ponumber.
SELECT SINGLE podate
poamount
vendorinv
vendordes
INTO (V_podate, V_poamount, V_vendorinv, V_vendordes)
FROM zpo_input
WHERE ponumber = v_pono.

now copy and paste this code and tell us which error it is giving?

just change in the where condition..

regards

shiba dutta

Message was edited by:

SHIBA DUTTA

Re: problem with select single statement

Former Member — Thu, 05 Apr 2007 06:10:16 GMT

Hi Line ,

One reason for this can be that you have not defined the varaibles used in the select statement , so please make please check if you have defined all the variables V_podate,V_poamount,V_vendorinv, V_vendordes .

Please check and if it still does not work , please paste your code here this would help us to identify the problem better,

Regards

Arun