main logo
Subject: Re: [V4RB] Bug with large results in SUM()
Author: erne
Posted: 2002/06/27 10:29:37
 
View Entire Thread
New Search


Hi J=F6rg,

>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
>

IIRC RB allows no LLong integers
maybe you could try

cur.Field(1).Getstring

and see what comes up

or try store cur.ULLongField(1).value into a double...


Cool Runnings,
Erne.

|er| musical box
|ne| a media store
 
©2002 erne
<-- Prior Message New Search Next Message -->