topic Re: problem with select-options in Application Development and Automation Discussions

problem with select-options

Former Member — Thu, 13 Dec 2007 08:53:35 GMT

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

Re: problem with select-options

Former Member — Thu, 13 Dec 2007 08:56:17 GMT

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

check the ztable once again for data.

Re: problem with select-options

Former Member — Thu, 13 Dec 2007 08:57:34 GMT

Hi,

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

Thanks,

Sreeram.

Re: problem with select-options

Former Member — Thu, 13 Dec 2007 08:58:17 GMT

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.

Re: problem with select-options

Former Member — Thu, 13 Dec 2007 08:58:29 GMT

Its better to debug.

regards

karthik