problem with select-options

[Former Member]

Hi guys,

i have a problem with my select-options...

SELECT-OPTION: s_days FOR zstatus-zdays.

SELECT * FROM zstatus

INTO TABLE i_status

WHERE zsapid = p_sapid

AND zdays IN s_days .

I dont understand why,,, instead of getting only the values from 1 to 5 (my input in s_days) from the table it selects entries beyond and within 1 and 5.

Your help is greatly appreciated.

Thanks!

Regards,

Mark

[Former Member]

put a breakpoint on select and see what exactly is happening.

check the ztable once again for data.

[Former Member]

Hi,

what is the data type of the field zstatus-zdays?

Thanks,

Sreeram.

[Former Member]

Hi,

may the the field zstatus-zdays is CHAR type then in that case it will the values like 18,100,28,...

to solve this make the field zstatus-zdays as type N(if it holds only numerical values).

rgds,

bharat.

[Former Member]

Hi

Its better to debug.

regards

karthik