topic Re: select query condition... in Application Development and Automation Discussions

select query condition...

Former Member — Thu, 02 Mar 2006 16:02:02 GMT

Hello,

I need to pick up a value from a table which is closest to another value.

For eg i need to pick up a qty ie closest to 6 and not equal to 6.

It might be 5 or 7.(which ever closest is available)

is there any other way to give a where condition than the not equal to....?

thanks,

Larry

Re: select query condition...

Former Member — Thu, 02 Mar 2006 16:05:09 GMT

You can try this -

Get all the data into internal table. Loop at the internal table and check the condition for the specified field.

Re: select query condition...

vinod_gunaware2 — Thu, 02 Mar 2006 16:11:12 GMT

U can use round and trnacate function.

suppose u have value 4.5 take to value

4 and 5 use <b>BETWEEN</b> condition in where condition.

this may be useful.

regards

vinod

Re: select query condition...

Former Member — Thu, 02 Mar 2006 16:11:50 GMT

I don't think, you need to load all data and then control which is the closest value, something like following code:

CHECK_VALUE = 6.

SELECT * FROM <TABLE> WHERE ......

DELTA = ABS( <TABLE>-QTY - CHECK_VALUE ).

IF DELTA < DELTA_OLD.

DELTA_OLD = DELTA.

OK_QTY = <TABLE>-QTY.

ENDIF.

ENDSELECT.

Max

Re: select query condition...

Former Member — Thu, 02 Mar 2006 16:16:23 GMT

Max,

will it not be good to do this processing using internal tables rather than in SELECT - ENDSELECT.

We can define lower range and higher range. And delete data from internal table which does not fall in this criteria. (< lower range and > higher range)

ashish

Message was edited by: Ashish Gundawar

Re: select query condition...

Former Member — Thu, 02 Mar 2006 16:20:38 GMT

Yes of course!

I wrote only an example to explain the logic.

Max

Re: select query condition...

Former Member — Thu, 02 Mar 2006 16:29:47 GMT

Well I shall try...Thanks guys for your replies...

Larry