[V4RB] GROUP returning too many records

[Ruslan Zasukhin]

on 6/5/03 3:00, Stan Busk at maxprog at mac.com wrote:

> Hi,
> 
> I have tried:
> 
> SELECT Sum(Amount)
>   FROM Accs
>   WHERE Type1='3' OR Type2='3'
>   GROUP BY Type1, Type2
>   ORDER BY Type1, Type2
> 
> and
> 
> SELECT Sum(Amount)
>   FROM Accs
>   WHERE Type1='3' OR Type2='3'
>   ORDER BY Type1, Type2
>   GROUP BY Type1, Type2
> 
> Both return a NIL cursor, anyway I really don't understand how a ORDER
> BY can help here when two group fields. About the Account field, it is
> a VDouble and I can't change it as I need doubles. Changing any other
> type will be very dangerous for the whole app integrity.
> 
> By the way, it works fine if type is anything else that 3, and type 3
> is the most common type in my database.

Stan,

Send me please small database with this one table.
I will try query it from viSQL.

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