topic Re: Regarding range tables in Application Development and Automation Discussions

Regarding range tables

Former Member — Tue, 24 Apr 2007 06:11:12 GMT

Hello,

I have a range table which gets populated with the following data.

S.....O.......Low................High

I......BT......<lower id>.......<higher id>

I need to do some processing for each of the values in the range table, ie, all ids in the 'between' range. How do i get the individual ids in that range?

Regards,

Suraj

Re: Regarding range tables

Former Member — Tue, 24 Apr 2007 06:21:51 GMT

in that case u have to get all the values which falls in this ranges.

select * from t001w into table i_t001w where werks in r_werks.

so here i_t001 will contains all the records which falls for given range.

Regards

prabhu

Re: Regarding range tables

Former Member — Tue, 24 Apr 2007 06:22:57 GMT

Hi,

The question is not clear , please mention waht kind of processin u want

and how is the range filled ( through some user input or something else ) ...based on waht ?

Thanks

Soumyadip Pal

Re: Regarding range tables

RaymondGiuseppi — Tue, 24 Apr 2007 06:24:11 GMT

If you range refer to a transparent table/databse view use you range in a select instruction to get individual values :

SELECT field FROM table WHERE field IN range.

Regards

Re: Regarding range tables

Former Member — Tue, 24 Apr 2007 06:26:15 GMT

Hello Suraj,

Its not a good practice to validations on range tables, try to avoid it. If it has to been done, then check the entries from where your taking the values to populate the table depending on range.

Regards

Re: Regarding range tables

Former Member — Tue, 24 Apr 2007 06:31:06 GMT

Hello,

Thank you all for your inputs.

In my case, the user would enter either one or a range of ids ( this is master data).

I need to get the details for each of these ids. The selection criteria entered by the user would be filled in a range table.

My range table can have EQ or BT in that case.

I now need to hit the DB to get the values of these ids.

Can i still do a select * from table where id IN <range table name>.... even though it has both EQ and BT entries? Will it work?

Regards,

Suraj