SET VAR vStartValue INTEGER
PROPERTY ... get the value into the variable
SET VAR vLowValue INTEGER = (INT(0.9 * .vStartValue))
SET VAR vHighValue INTEGER = (INT(1.1 * .vStartValue))
... WHERE ValueColumn BETWEEN .vLowValue and .vHighValue
That might give you some ideas.
Albert
On 2015-08-28 11:09 AM, Bill Eyring wrote:
I have the need to create a filter on an enhanced DBGrid column.
I know how to create filters but I need to create some code in an
Enhanced Speed Button to create a filter that will filter an integer
column that will select rows that are between 10% higher and 10%
lower than a specified value.
Example: Value =2000
I need to display all rows that are between values 1800 to 2200.
How can I accomplish this ?
Thanks,
Bill Eyring
