Subject Re: [firebird-support] Filtering
Author Ann W. Harrison
On 1/20/2011 10:45 AM, Woody wrote:

>> as_the_filter := StrToFloat(number1) + '>=' + FloatToStr(lo_nbr) + ' and '
>> + StrToFloat(number1) + '<=' + FloatToStr(hi_nbr);
>>
>
> ... They
> should all read IntToStr anyway since you are only using integers and not
> floating point variables.
>
> Woody (TMW)

Do be sure the Int in the functions is a 64bit integer - conversions to
smaller integers will fail and conversion to single or double precision
floating point will lose accuracy.


Good luck,

Ann