Subject Re: [firebird-support] SP float results rounded strangely (dbExpress)
Author Lester Caine
Martijn Tonies wrote:

>>isql gives
>>0.66666669
>>
>>so it seems to be client issue. How big is float in Firebird?
>
> A client issue? Howso? "isq" returns an answer just as wrong as
> Delphi.

What is 'wrong' is that the client is displaying information that is
simply not storable in the underlying data field. It WOULD be nice if
one could limit the client to just show the 'accuracy' that is possible
and at least warn where something is not possible - so it is a client
issue.

The isql answer is limited to the available accuracy, but the data
supplied can simply not be handled and was simply trimmed even before
the result was generated?

Personally I avoid FLOAT simply because of the rounding problems ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services