topic Re: Range table in Application Development and Automation Discussions

Range table

Former Member — Thu, 09 Mar 2006 20:43:34 GMT

Hi experts,

I am trying to use a range table.

Anyone can tell me how to define a range table like this?

fieldname~~-sign~~-option~~-low~~-high

zip-I-eq---30152

zip-I-bt~~-30111~~-30113

yeare-lt---2005

etc etc....

Zip and Year are different data type of course.

I saw this example here

Thanks in advance!

Re: Range table

RichHeilman — Thu, 09 Mar 2006 20:45:42 GMT

You can do the ZIP like this.




report zrich_0001 .

data: zip(5) type n.


ranges: r_zip for zip.

REgards,

Rich Heilman

Re: Range table

RichHeilman — Thu, 09 Mar 2006 20:48:25 GMT




data: zip(5) type n.
data: year(4) type c.


ranges: r_zip for zip.
ranges: r_year for year.


clear r_zip.
r_zip-sign   = 'I'.
r_zip-option = 'EQ'.
r_zip-low    = '30152'.
append r_zip.

clear r_zip.
r_zip-sign   = 'I'.
r_zip-option = 'BT'.
r_zip-low    = '30111'.
r_zip-high   = '30113'.
append r_zip.

clear r_year.
r_year-sign   = 'E'.
r_year-option = 'LT'.
r_year-low    = '2005'.
append r_year.



if p_zip in r_sip
  and p_year in r_year.
  
  
  
endif.

REgards,

Rich Heilman

Re: Range table

Former Member — Thu, 09 Mar 2006 20:52:54 GMT

I think that in that example, they were trying to build a dynamic where clause out of multiple ranges. I don't think you can have multiple fields in a single range table.

Rob

Re: Range table

Former Member — Thu, 09 Mar 2006 20:57:10 GMT

Hi Linda,

Just use statement.

RANGES: R_ZIP FOR ADRC-POST_CODE1,

R_YEAR FOR YEAR.

R_ZIP-SIGN = 'I'.

R_ZIP-OPTION = 'EQ'.

R_ZIP-LOW = '30152'.

APPEND R_ZIP.

R_ZIP-SIGN = 'I'.

R_ZIP-OPTION = 'BT'.

R_ZIP-LOW = '30111'.

R_ZIP-HIGH = '30113'.

APPEND R_ZIP.

R_YEAR-SIGN = 'E'.

R_YEAR-OPTION = 'LT'.

R_YEAR-LOW = '2005'.

APPEND R_YEAR.

Re: Range table

Former Member — Thu, 09 Mar 2006 21:10:32 GMT

Thank you all guys.

Doubt cleared.

It is impossible to put two different fields in one range table.

Points awarded!

Linda