Hello All

Im using Firbird 1.5 and Im doing a SQL "SUM" on the following
values:-

-384.09
0
128.03
256.06


all in different rows on a Double Precision Data Type

but instead of return a zero value it returns a ridiculously high
value like 46 trillion.

SQL = "SELECT SUM( CODETITLEPOSITION4_TOTAL ) CODETITLEPOSITION4
FROM ORDER_MONTHLY_SUMMARY_TABLE
WHERE BASICINPUTID = 12"

This only occurs when Im executing the SQL vis IB components and NOT
direct in IBExpert.

Any ideas why ?

tia
Andrew