topic Re: problem in coding : ranges , plz help in Application Development and Automation Discussions

problem in coding : ranges , plz help

Former Member — Mon, 16 Jun 2008 14:27:59 GMT

Hi Friends:

Plz see my sample code below:

r_rundate-sign = 'I'.

r_rundate-option = 'EQ'.

r_rundate-low = '20080613'.

r_rundate-high = '20080613'.

APPEND r_rundate.

r_runtime-sign = 'I'.

r_runtime-option = 'EQ'.

r_runtime-low = '153017'.

r_runtime-high = '153042'.

APPEND r_runtime.

SELECT objectclas objectid changenr udate utime

FROM cdhdr

INTO TABLE lit_cdhdr

WHERE objectclas = 'IDENTITY'

and utime IN r_runtime

and udate IN r_rundate.

now the problem is that its picking only one line item while in the table there are 2 line items exists. the problem is that its picking only the data for r_runtime-low. its not picking up data for r_runtime-high. Objectclas is key field while utime & udate are not.

I want to pick both the items from the table. Id I remove the condition of utime from my query, it fetches both the items.Plz help.Points will be rewarded.

Re: problem in coding : ranges , plz help

ThomasZloch — Mon, 16 Jun 2008 14:32:50 GMT

replace EQ with BT when filling "option".

Thomas

Re: problem in coding : ranges , plz help

Former Member — Mon, 16 Jun 2008 14:33:29 GMT

Hello,

Change the code like follows:


r_runtime-sign = 'I'.
r_runtime-option = 'BT'. "Change to between
r_runtime-low = '153017'.
r_runtime-high = '153042'.
APPEND r_runtime.

Regards

Re: problem in coding : ranges , plz help

Former Member — Mon, 16 Jun 2008 14:35:53 GMT

Thanks for the help..

Re: problem in coding : ranges , plz help

Former Member — Mon, 16 Jun 2008 14:36:08 GMT

if you fill the ranges

r_rundate-sign = 'I'.

r_rundate-option = 'EQ'.

r_rundate-low = '20080613'.

r_rundate-high = '20080613'.

APPEND r_rundate.

EQ = 'equal', the select check the record with data EQ r_rundate-low.

change EQ with BT

BT = between

r_rundate-sign = 'I'.

r_rundate-option = 'BT'.

r_rundate-low = '20080613'.

r_rundate-high = '20080613'.

APPEND r_rundate.

reward if useful, bye