problem in coding : ranges , plz help

[Former Member]

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.

[ThomasZloch]

replace EQ with BT when filling "option".

Thomas

[Former Member]

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

[Former Member]

Thanks for the help..

[Former Member]

Hi

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