[V4RB] GROUP returning too many records

[Ruslan Zasukhin]

on 6/5/03 2:11, Gunnar Swan at GunnarSwan at practicetopass.com wrote:

> 
> Check the data type of field "Amount"
> Experiment with different data types on this field.
> If I remember correctly, Aggregate functions did not work with some field
> types. 

This was true for string fields.
And this bug fixed in latest 1.9.8 betas

> Again, my feeble memory, but I remember we had to change the field type to get
> things to sum correctly.
> 
> Also, I think you will need to use ORDER BY, and sort records according to
> GROUP.

Not required.  
GROUP by self do sorting.

> Other databases all you to skip ORDER BY .. it's implied. Valentina ( I think
> ) requires ORDER BY.
> 
> Also, I think it was particular ... it wanted ORDER BY first in SQL, then
> GROUP BY.
> In any case, once we went through these items, it worked perfect.

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