Subject Re: [firebird-support] Filtering
Author Woody
From: "Ann W. Harrison" <aharrison@...>
> 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.
>

Not sure about latest Delphi, but earlier versions have Int64 that could be
used in place of integer (32 bit). Anyway, topic is off-course for FB so
I'll leave it there.

Woody (TMW)