hi all

[Former Member]

hi all

SELECT single mxwrt gkwrt konwa into

( loc-min_amount ,loc-max_amount ,loc-curr ) FROM konp where knumh = wf_knumh.

in the above i am getting 'COMMA WITOUT PRECEEDING COLON ERROR) .

I made alll the combinations.

suggest me any way

[Former Member]

hi all

SELECT single mxwrt gkwrt konwa into

( loc-min_amount ,loc-max_amount ,loc-curr ) FROM konp where knumh = wf_knumh.

in the above i am getting 'COMMA WITOUT PRECEEDING COLON ERROR) .

I made alll the combinations.

suggest me any way

[Former Member]

<b>SELECT single mxwrt gkwrt konwa into

( loc-min_amount, loc-max_amount, loc-curr ) FROM konp where knumh = wf_knumh.</b>

try to use the querry in this format

[Former Member]

there is space problem....

SELECT single mxwrt gkwrt konwa into
(loc-min_amount, loc-max_amount, loc-curr) FROM konp where knumh = wf_knumh.

after comma ( , ) one space and no space between (loc-min_amount and loc-curr)

regards

shiba dutta

[Former Member]

Hi

Hi try giving spaces.

Message was edited by:

Raghu Reddy

[Former Member]

Hi,

Pls dont give any space between brackets and comma. Try this.

SELECT single mxwrt gkwrt konwa into

(loc-min_amount,loc-max_amount,loc-curr) FROM konp

where knumh = wf_knumh.

regards,

Niyaz

[Former Member]

Hi,

SELECT single mxwrt gkwrt konwa into

( loc-min_amount, loc-max_amount, loc-curr ) FROM konp where knumh = wf_knumh.

[Former Member]

Hi ,

Use this code now.

SELECT single

mxwrt

gkwrt

konwa

into (loc-min_amount ,loc-max_amount ,loc-curr)

FROM konp

where knumh = wf_knumh.

I have removed the space in <b>(loc-min_amount ,loc-max_amount ,loc-curr)</b>

Check and reward.

Regards

Nivetha

[Former Member]

Hi,

I guess error because of comma positions ...try like this:

SELECT single

mxwrt

gkwrt

konwa into

( loc-min_amount, loc-max_amount, loc-curr )

FROM konp where knumh = wf_knumh.

[hymavathi_oruganti]

no need of comma, just give space in between each field

[varma_narayana]

Hi ..

Try this way..

SELECT single mxwrt gkwrt konwa

into <b>(loc-min_amount ,loc-max_amount ,loc-curr)</b> FROM konp where knumh = wf_knumh.

Note: there is no need of SPACE after the Open Brace and before the Closing brace.

REWARD IF HELPFUL.

[Former Member]

Hi

You have put a space at wrong place.

1. Space after (.

2. Space befoer ,. These were the mistakes.

The corrected query is as follows. Just copy the same thing i hace written below:

SELECT single mxwrt gkwrt konwa into

(loc-min_amount, loc-max_amount, loc-curr ) FROM konp where knumh = wf_knumh.

<b>PLZ Reward points if helpful</b>