Hi,

At April 18, 2005, 23:24, Geoff Worboys wrote:

> It seems likely to me that we are dealing with a field that is
> represented as a floating point. I have never really studied
> the AVG code to see what type it returns under various
> conditions. I suspect that the problem may be that TIB_Query
> is looking at the data type (NUMERIC(15,2)) and treating it as
> a scaled integer - whereas TIBOQuery is reading it as a
> floating point.

TIBOQuery reads it as a BCD, not as a floating point.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)