Using the SUM() function yields to different results than calculating the
sum by hand:
e.g.
cur =3D SQLSelect("select Sum(Length) from Tracks")
d =3D cur.ULLongField(1).value
d is 308724735
versus:
cur =3D SQLSelect("select Length from Tracks")
do
d =3D d + cur.ULongField(1).value
loop until (cur.nextRecord =3D false)
d is 262301729791
This seems to happen only if there is a great number of records or a very
high sum. I tried it with 46642 records.
Could it be that there is a overflow in the SUM() function?
Cheers,
J=F6rg
____________________________________________
three-2-one interaktive Medien GmbH
joergp .at. three-2-one .D.O.T com
http://www.three-2-one.com
fon: +49 2151 319450
©2002 Joerg Pressel |
