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

[Ruslan Zasukhin]

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