[V4MD ver 1.9.8] using Sum() returns a null value

[Mahesh Markus]

1. I am not allowed to use a beta version.

2. However, the field type is Long.

3. Strange indeed



-----Original Message-----
From: Ruslan Zasukhin [mailto:sunshine at public.kherson.ua] 
Sent: Thursday, 18 December 2003 7:32 PM
To: valentina at lists.macserve.net
Subject: Re: [V4MD ver 1.9.8] using Sum() returns a null value


on 12/18/03 2:26 AM, Mahesh Markus at maheshm at uniqueworld.net wrote:

> I am using the aggreate function SUM() as in the following query:
>   SELECT Sum(number)
>   FROM tblInformation
>   WHERE tblInformation.ID = 23
> 
> Howver, both avg() and count() work.
> 
> I am temporarily using avg() * count() to get the correct figure.
> 
> Any suggestions.

Hi Mahesh,

Strange, must works.

1) what Valentina version you use?
    try 1.10b22

2) what type have field number ?

3) Hmm, AVG(number) works?
    but AVG just do SUM self, then divide on count....
    



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina