[V4MD] problem w/ Group By

[Ruslan Zasukhin]

on 3/14/03 9:52 PM, X Y at xyzabc1010 at yahoo.com wrote:

> This is the problem, I am asking about.. I used the
> cursor and still got different results.
> 
> In addition, if I have only one record in the db and
> use an AVG or SUM or COUNT, nothing gets return. For
> instance, I have
> 
> SELECT name, SUM(val) FROM A WHERE name = 'foo' GROUP
> BY NAME
> 
> Lets say
> the sql "SELECT * FROM A WHERE name = 'foo'" returns
> one record. Using the aggregate statement above,
> however, return nothing.
> 
> Any ideas?
> THANKS!!!

Is this reproduced in viSQL also ?

If yes, then pelase send me this db with this table with this one record,
I will test it in viSQL under debugger.

May be bug for 1-record table ?

If table have 2 records it start works ?

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------